This was working for me until I installed Office 2010...
tlcExcelFileName = GETFILE('xls')
oExcelObject = CREATEOBJECT('Excel.Application')
oExcelWorkbook = oExcelObject.Application.Workbooks.Open(tlcExcelFileName)
oExcelWorkbook.ActiveSheet.UsedRange.EntireColumn.AutoFit()
oExcelWorkbook.Save
oExcelObject.Quit()
oExcelObject = NULL
...now it's giving me an error when it gets to the oExcelWorkbook.save() line.
Any ideas?
Thanks!
ICQ 10556 (ya), 254117