method "open" of object "workbook" failed

P

Paul Hewson

I have a program that runs on our sever (w2k) It uses Excel automation to
generate some reports. This program has been working for two years, but now
halts when I try to open a workbook. The error message is the same as in
the subject. We have already tried uninstalling and reinstalling Excel to
no avail. If I convert calls to late bound calls, they work OK. It is only
early bound automation that is failing (Trying to add a workbook to the
workbooks collection will also cause it to fail.) The file it is trying to
open is the same and in fact the program runs well enough from a different
workstation. But I would like to repair excel on the server to make it run
smoothly again. I wonder if there is a DLL somewhere that has been updated
that is more recent than the installation copy and thus not being removed on
uninstall. If anyone has any ideas, I would love to hear them, by email or
here. TIA.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top