Click to See Complete Forum and Search --> : working with offline sql server data in excel


rizshe
05-30-2006, 11:11 AM
Hello,

I am trying to follow this example from msdn:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/odc_vsto2003_ta/html/odc_VSTSQLExcl.asp

I have VStudio 2003 and Office 2003 installed. When i try to go to the code section it first open VBA with version 6.3. Then when i'm writing the code it just doesn't work.
The main problem occur near Try block when you're trying to catch an exception.
Its not even giving the option as exception the only options i found was
Exceptioninfo and its giving the error on as.
Can any body help?

Regards,
Riz