Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 OLE

Author  Topic 

LopakaB
Starting Member

22 Posts

Posted - 2012-02-29 : 14:48:04
OS: windows 2008 r2 standard sp1
sql: 2000 sp3
Error: Server: Msg 50000, Level 16, State 1, Line 133
"Unable to get the Open property of the Workbooks class"

Have have several sp that import/export data to excel spreadsheets...
All work fine on all of our other servers up to win2008, not with r2. So after an hour of trial and error with excel, i tried opening a text file; no problem...
Can anybody point me in the right direction, or even a fix?
Thank you.

Lopaka
   

- Advertisement -