VBA reference to MSOWC.DLL

I am experiencing a problem when I use the MS Office Spreadsheet control
(9.0) in my AutoCAD VBA apps.
Our computers have MS Office installed.
The references seem to be in tact but an error is displayed when code runs.
The error says that a variable has not been defined. In fact, the variable
is defined as public in a code module.
If that error is cleared another error reports that a function is unknown
but the function has a public scope and is in a code module.
I check the References but there are none missing or broken.
Our computer systems (20 of them) are nearly identical but this problem does
not occur on all systems.

What might be causing these errors?

 

Mark,

I use this the owc10.dll control to avoid problems I give every
user the same copy of the owc10.dll and have them install it in the same directory. the they must usee regsvr32 to register it. I also include a reference to this dll file in the
autocad vba ide which must be the same directory for each user. what are you using this owc.dll for
you can e-mail me at
if you want

fred c

 

I'm using the Spreadsheet control for data input on a form.

I'm not sure that msowc is the problem. I might have some systems where the
dll doesn't get registered properly.

directory. the they must usee regsvr32 to register it. I also include a
reference to this dll file in the