GetObject Word97/2000 Problem

[SgtPepps]

I've used the following code in a Word2000 procedure...

Set ObjectVariable = GetObject("C:\Dir\Spreadsheet.xls&quot

... however when i run the procedure with Word97, i get the error:

"Run Time Error 429 - Can't create ActiveX component"

When the spreadsheet opens, the "Workbook_Open" procedure is supposed to load and show a Form. It looks like the .xls is being opened and you can see that the form almost opens but then the form disappears, the .xls stays open and the error message pops up. As far as i'm aware the GetObject function is avaliable in Office 97 VBA and is coded the same. Any Ideas?

Mike

 

[SgtPepps]

I've realised that its not the loading of the form that causes the error. I've got some code within the form that opens a .dbf in excel. Excel97 can deal with this but for some reason Word97 dosn't like automating the opening of the .dbf in excel. I'm going to look into it further.