Thread: Automation
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Frank juszli Frank juszli is offline
external usenet poster
 
Posts: 1
Default Automation

Thanks Bill for the response. I appreciate it.

I know about references and it isn't the reference unless
you know something I don't. With 97 I ref excel 8.0
object library and with 2000 I ref excel 9.0 object
library. The problem seems to be the way the operating
system is acting. Is there any reason why excel 97
wouldn't work on a Windows 2000 machine?

Thanks again Bill,

Frank Juszli

-----Original Message-----
Hello Frank,

Maybe the ref is missing when run Excel 2000 file in

Excel
97.

Best Regards

Bill

-----Original Message-----
Hello all,

My problem is this ...... I've developed a small app in

VB
6.0 that inserts images into an excel 97 worksheet. The
program works great on Windows 98 machines and I have it
working on a Windows 2000 machine using Excel 2000 but
when I run the app on a Windows 2000 machine using excel
97 It doesn't want to create the excel workbooks object.
It says "the add method of the workbooks object failed"

any idea why this happens?????? Please ....

Frank Juszli
.

.