VB error with Office Toolkit 4.0

[GoogleCodeExporter]

What steps will reproduce the problem?
1. install office toolkit 4.0
2. install excel connector
3.

What is the expected output? What do you see instead?
get a VB debug screen showing line 136 in AutoExec module
"Set sfot = New SForceSession4 ' if this fails we dont have the new toolkit"

What version of the product are you using? On what operating system?

Please provide any additional information below.

Original issue reported on code.google.com by tonyc...@gmail.com on 31 Oct 2009 at 12:57

Attachments:

• sforce_connect.xla
• [SForce Office Toolkit.msi](https://storage.googleapis.com/google-code-attachments/excel-connector/issue-1/comment-0/SForce Office Toolkit.msi)

[GoogleCodeExporter]

On the VB debug screen click on Tools>Reference and see if anything is missing. 
 I've
noticed that if you install Office SP1 usually fixes this issue.

Original comment by Howard.H...@gmail.com on 7 Jan 2010 at 3:47

[GoogleCodeExporter]

I've got the most recent versions of Office and Outlook connect as well as the 
most
recent Excel connector all installed. When I launch excel, after enable macros 
I get
a VBA error: "Compile error: Object library invalid or contains references to 
object
definitions that could not be found." In tools/references there is 1 checked 
box with
"MISSING": "Ref Edit Control". 
I've been struggling with this ALL day...please help.
Thanks

Original comment by Benjamin...@gmail.com on 9 Apr 2010 at 9:23

[GoogleCodeExporter]

I get the same "Set sfot = New SForceSession4 ' if this fails we dont have the 
new toolkit" Error, with new toolkit, and office 2007, going to try to install 
sp2

Original comment by ht.text...@gmail.com on 29 Jul 2010 at 8:31

[GoogleCodeExporter]

If you have a machine with Windows 7 Os and MS office 2007 or 2003, you may 
find difficulties while loading the EE connector.

If you get a dialogue box with the following message, read further.
On References sforce connector popup ,"Missing Ref Edit" (check box will be 
ticked) C:\Program files\Microsoft Office\OFFICE11\REFEDIT.dll
The references box only pops up the first time you enable the connector. To get 
it to come up again, turn off the connector, by unticking the "Sforce_Connect" 
Add-in in the Add-ins setup menu, exit Excel, open Excel and turn it back on.

Anyway, to fix the issue, just uncheck Missing Ref Edit Control and click 'Ok' 
in the references box. Each time you open up the sforce connector, you may have 
to go through the same procedure. Not sure, but I think that if you are running 
Office 2007 only, then you may avoid repeating this procedure each time, by 
adding the attached 2003 version of the REFEDIT.DLL file in the exact location 
noted above.

Original comment by jwil...@orcon.net.nz on 9 Nov 2010 at 9:24

Attachments:

• REFEDIT.DLL

[GoogleCodeExporter]

>>Each time you open up the sforce connector, you may have to go through the 
same procedure.

In order to avoid having to repeat this procedure, it looks like you just need 
to open the Visual Basic Editor and save the xla file, immediately after 
unchecking the Missing Ref Edit Control.

Original comment by jwil...@orcon.net.nz on 9 Nov 2010 at 10:18

[GoogleCodeExporter]

I've updated the XLA to remove this reference, let me know if new one works, 
look for _ee_1602

Original comment by vneh...@gmail.com on 24 Nov 2010 at 4:06

• Changed state: Fixed