J
Johnny Eager
I have written code that is to be used on all versions of Word/Excel.
This code works in all versions Windows (97, 2000, XP), OS9 (98, 2001), and
OSX (10.0+)
However in Word X/Excel X, for no apparent reason, this string causes Word
on some machines to unexpectedly quit leaving Excel open. The variables are
set correctly. Option Explicit is set. It works on a majority of machines
tested, but crashes on enough to be a problem.
Set xlApp = CreateObject("Excel.Application")
xlApp.Workbooks.Open FileName:=sXLtmp, Editable:=True
xlApp.ActiveWorkbook.SaveAs FileName:=sXLdoc
Has anyone had problems with automation in Office 10?
Thank you in advance.
je
This code works in all versions Windows (97, 2000, XP), OS9 (98, 2001), and
OSX (10.0+)
However in Word X/Excel X, for no apparent reason, this string causes Word
on some machines to unexpectedly quit leaving Excel open. The variables are
set correctly. Option Explicit is set. It works on a majority of machines
tested, but crashes on enough to be a problem.
Set xlApp = CreateObject("Excel.Application")
xlApp.Workbooks.Open FileName:=sXLtmp, Editable:=True
xlApp.ActiveWorkbook.SaveAs FileName:=sXLdoc
Has anyone had problems with automation in Office 10?
Thank you in advance.
je