Hi,

This was what worked for me, which would be merely in addition to what was posted above.

I. Follow the steps from this site:

http://prasanth4microsoft.blogspot.com/2010/11/windows7-excel-vba-ora-01019-unable-to.
html

1) Change User Settings
Navigate to : Control Panel > User Accounts > User Accounts > "Change User Account
Control settings"
Set the value as "Never Notify".
Click on Ok button.

2) Grant "Create global objects"
Navigate to : Start > Run > gpedit.msc
In Local Group Policy window, Navigate to : Computer Configuration\Windows
Settings\Security Settings\Local Policies\User Rights Assignment"
Select "Create global objects", right click and navigate to properties windows
Click on "Add User or Group" button and add users to this group

3) Delete existing XSD files

In Windows XP:
CD \Document And Settings
DEL /S /A:H /A:-H *.EXD
In Windows 7 or Vista:
CD \Users
DEL /S /A:H /A:-H *.EXD

NOTE: Make sure that there's a confirmation that the files were deleted before going to step 4 as you might be required to close certain applications.

4) Reboot machine

II. If you continue to get the same error, then try these:

1.) Open Excel File
2.) Hit Alt+F11 (This will take you to the VisualBasic Editor)
3.) Click on View
4.) Click on View Objects
5.) Search for "ThisWorkbook"
6.) Right click on ThisWorkbook
7.) Choose References
8.) Tick on Sforce Connector and Office Toolkit 4, depending on the version that you're using

9.) Go back to your workbook by hitting Alt+F11 again