Excel 97 problem

[Benjamin]

Hello

I have one big problem recently with my in house problem
(VB programe) with excel 97. When linking with my excel i
have error message stating "method '~' of object '`'
failed". But if i run the systems with office 2000, excel
there isn't any problem with that.

I wonder is it because of the regular updating from
microsoft that affect the excel 97 worksheet. And it
happen to all windwos 2000 professional. Can anyone help
me on this, many thanks!

Benjamin

 

[jaxdlp]

Most likely, you have a reference problem. When this
happens, break into the program in debug mode, open the
ide in code view and look in the tools menu at your
references. You'll probably have an item listed toward
the top of the list as "MISSING:...". This can happen
easily if you're running more than one version of office
products on the same machine or if you run the same app on
various machines with varying versions of office products.

-Dave
Jax, FL