function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
orzikorzik 

RE: Excel connector installation problem

I had similar issue to tghe one described in the following thread
Community : Developer Boards : VB and Office Development : Excel connector installation problem
This is what I did and highly recommend to others.
Find and edit below code as noted below and run manually when needed...

--------------------------------------------------------------------------
Sub Auto_Open()
On Error Resume Next
' CommandBars(IDS_TOOLBAR_NAME).Delete ' not neeeded each open
' CommandBars("Salesforce").Delete ' remove old toolbar
--------------------------------------------------------------------------

For those of you who do not know... Above code is commented so that it does not run each time...
Remove second comment ('), if you would like to remove old toolbar, and run the code manually. Please note that original tollbar name is "sforce connector" in the code below I replaced it with "your toolbar name here". See below modification 1:

Modification 1
--------------------------------------------------------------------------
Sub Auto_Open()
On Error Resume Next
' CommandBars(IDS_TOOLBAR_NAME).Delete ' not neeeded each open
CommandBars("your toolbar name here").Delete ' remove old toolbar
--------------------------------------------------------------------------

After that, put the second comment back in, and you can add your new Add-in or remove first comment (') and run the code. See below modification 2:

Modification 2
--------------------------------------------------------------------------
Sub Auto_Open()
On Error Resume Next
CommandBars(IDS_TOOLBAR_NAME).Delete ' not neeeded each open
' CommandBars("your toolbar name here").Delete ' remove old toolbar
--------------------------------------------------------------------------

Ron,
If you read this message please consider placing this solution on the sforce connector FAQ page

Should anyone have questiones about this please email me at gorzik@gmail.com.
grg orzikowski