When I use
Set xlApplication = CreateObject("Excel.Application")
.
.
.
Set xlWorkbook = xlApplication.Workbooks.Open("c:\CashFlow Template.xls")
I get an run time error. This worked fine for a while and then just stopped. It still works on some machines but not others??? The accompanying message is "Server threw an exception" and a big negative error number. The help comment relates to 'Automation' objects but I can't figure out the relevance of that. Can anyone help? It would be most appreciated.
With thanks
Set xlApplication = CreateObject("Excel.Application")
.
.
.
Set xlWorkbook = xlApplication.Workbooks.Open("c:\CashFlow Template.xls")
I get an run time error. This worked fine for a while and then just stopped. It still works on some machines but not others??? The accompanying message is "Server threw an exception" and a big negative error number. The help comment relates to 'Automation' objects but I can't figure out the relevance of that. Can anyone help? It would be most appreciated.
With thanks