Depends on what you need.
Use saveas to save in the current Excel Version (otherwise formatting may be lost):
ObjExcel.ActiveWorkbook.SaveAS("c:\outfile.xls",xlDefault)
or save it in original file format without user interaction:
ObjExcel.DisplayAlerts = .f.
ObjExcel.ActiveWorkbook.Save()
> Hi all, got a simple problem that i need your help with.
>
> I am using copy to ??? type xls. then i am opening the excel file with automation, making some changes and saving it, all works fine but i get a message asking me if i want to update to the latest version. I know you can suppress these messages but i can't remmember how, and that is my question, simple?
>
> many thanks,
>
> Craig
COMPLETE THREAD
|  | | Excel Save Posted by Craig Moore @ 4/17/2003 10:49:52 AM |
|