Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
SaveAs method
I am trying to automate a spreadsheet that uses DDE links to get data & save
it out to a comma delimited file to import into Access & would like this to be seamless to the user (not having to respond to any messages). I am using the SaveAs method in the BeforeClose event of the Workbook. Actual code is: ActiveWorkbook.SaveAs FileName:="e:\shift Report\report\xtest", FileFormat:=xlCSVWindows This code works fine & it saves this file, but after this happens & Excel is being closed I get the standard message "File is not in Microsoft Excel 97 format. Would you like to save?" How can I bypass this message so the user does not have respond to this message?? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
SaveAs method
Add the following code to the end of your macro that flags that the workbook does not need saving.
ActiveWorkbook.Saved = True When the user closes the workbook, assuming no further changes have occurred, there should be no prompt for saving. -- John Green - Excel MVP Sydney Australia "L Buchy" wrote in message ... I am trying to automate a spreadsheet that uses DDE links to get data & save it out to a comma delimited file to import into Access & would like this to be seamless to the user (not having to respond to any messages). I am using the SaveAs method in the BeforeClose event of the Workbook. Actual code is: ActiveWorkbook.SaveAs FileName:="e:\shift Report\report\xtest", FileFormat:=xlCSVWindows This code works fine & it saves this file, but after this happens & Excel is being closed I get the standard message "File is not in Microsoft Excel 97 format. Would you like to save?" How can I bypass this message so the user does not have respond to this message?? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using SaveAs | Excel Discussion (Misc queries) | |||
Problem using SaveAs method | Excel Discussion (Misc queries) | |||
SaveAs method error | Excel Discussion (Misc queries) | |||
Please post this thread a correct full method, method about | New Users to Excel | |||
Please post this thread a complete correct method, method about te | New Users to Excel |