M
Maury Markowitz
Here's an access sub...
xl = CreateObject("Excel.Application", "othermachine")
xl.visible = true
msgbox(xl.version)
xl.workbooks.open "c:\theworkbook.xls"
xl.quit
Simple enough. If you run this on "othermachine" everything works perfectly.
If you run this from any other machine, it hangs on the open. IE, the version
works and is displayed properly on the local machine, but then it never
returns from trying to open the book.
Any ideas?
Maury
xl = CreateObject("Excel.Application", "othermachine")
xl.visible = true
msgbox(xl.version)
xl.workbooks.open "c:\theworkbook.xls"
xl.quit
Simple enough. If you run this on "othermachine" everything works perfectly.
If you run this from any other machine, it hangs on the open. IE, the version
works and is displayed properly on the local machine, but then it never
returns from trying to open the book.
Any ideas?
Maury