Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Yuri Rubinov
  Where is Yuri Rubinov?
 Philadelphia
 Pennsylvania - United States
 Yuri Rubinov
 To: Craig Moore
  Where is Craig Moore?
 
 United Kingdom
 Craig Moore
 Tags
Subject: RE: Excel Save
Thread ID: 22405 Message ID: 22418 # Views: 11 # Ratings: 0
Version: Visual FoxPro 7 Category: Microsoft Office Automation
Date: Thursday, April 17, 2003 3:41:40 PM         
   


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
RE: Excel Save Posted by Yuri Rubinov @ 4/17/2003 3:41:40 PM