You need to sign in to do that
Don't have an account?
jmcturnan
Excel connector installation problem
Hi, everytime I try any of the menu commands I get the message
"The macro c:\Documents and Settings\MCTURNANJ\Local Settings\Temp\sforce_connect.xla'!sfDescribeAndQuery' cannot be found"
I have uninstalled & reinstalled the Addin multiple times. I have tried uninstalling the Office toolkit.
Much appreciation & thanks in advance for helping me resolve this.
"The macro c:\Documents and Settings\MCTURNANJ\Local Settings\Temp\sforce_connect.xla'!sfDescribeAndQuery' cannot be found"
I have uninstalled & reinstalled the Addin multiple times. I have tried uninstalling the Office toolkit.
Much appreciation & thanks in advance for helping me resolve this.
if not, pls send the version you are using
Excel Connector - Moved xla file to a different folder and now connector won't work.
Question
I got the excel connector installed properly yesterday. But I noticed that I had saved it to a temporary folder, so I moved the .xla file to a different folder. Once I did that, whenever I tried to open the .xla file, it says that "the file could not be found. Check the spelling of the file name, and verify that the file location is correct." How can I uninstall, and reinstall all over again?
Answer
Yes, if you move the file you may have to uninstall the entry in the Add-In list of Excel and re-install it from the new location. This sounds easy, but it can be tricky because Excel thinks the old file exists until you really clear out the toolbar and entry from the add-in folder
I use steps like this:
Open Excel
click Tools, Add-Ins
uncheck the sforce_connect checkbox, click OK
close Excel
Open Excel again, if the "sforce_connector" menu bar is still there, right click on the tool bar area of excel, uncheck the sforce Connector check box
close Excel
open Excel
If the bar is gone and the Add-INs list is showing the add-in as unchecked or gone then you can re-install the add-in using the new file location of the XLA, see the install instructions Installation Guide for details on the install.
I wish i could tell you a better way to do this, but these steps work most of the time.
Thanks again for your help. This is a fantastic tool.
Regards,
John
sort of a big hammer, solution but may work.
BTW: Here is some info from MSFT that describes how Excel stores the location of Addin's in the registry
http://support.microsoft.com/default.aspx?scid=kb;en-us;810789
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
--------------------------------------------------------------------------
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 you can add your new Add-in or remove first comment ('), put the second comment back in 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
I tried a lot of things to get this to work, and I may have found something that I want to share
Just change the name of the macro file. I changed to excel_connector1.xla. That seemed to do the trick
OPh I knew that.
I ment this:
I had similar issue... this is what I did and highly recommend to others.
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
--------------------------------------------------------------------------
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 you can add your new Add-in or remove first comment ('), put the second comment back in 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
--------------------------------------------------------------------------