OK, I'm having an interesting problem. I wrote the following code on my system, (W2KP, Office XP) and it works fine:
Dim x as excel.applicaiton
set x = new excel.application
x.workbooks.open("myfile.xls"
obviously, it's more complex than this. On my system, running this code opens excel and this workbook for automation, but on an NT4 system with Excel 2000, the first line works, it starts up a hidden instance of Excel, but the second line causes a doctor watson. (Yes, I am referencing a valid file on both computers.)
What am I missing?
Dim x as excel.applicaiton
set x = new excel.application
x.workbooks.open("myfile.xls"
obviously, it's more complex than this. On my system, running this code opens excel and this workbook for automation, but on an NT4 system with Excel 2000, the first line works, it starts up a hidden instance of Excel, but the second line causes a doctor watson. (Yes, I am referencing a valid file on both computers.)
What am I missing?