| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
HOW 2 Auto Close and Save CSV file
Hi, all... I am trying to copy some values into a CSV file then close and
save both files. When I use ActiveWindow.save or ActiveWindow.Close on the CSV file it prompts my if I want to save it as is, and OF COURSE I DO... How can I accomplish this with out the prompts??? Thank you again.... |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
HOW 2 Auto Close and Save CSV file
Application.DisplayAlerts=False
"WANNABE" wrote: Hi, all... I am trying to copy some values into a CSV file then close and save both files. When I use ActiveWindow.save or ActiveWindow.Close on the CSV file it prompts my if I want to save it as is, and OF COURSE I DO... How can I accomplish this with out the prompts??? Thank you again.... |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
HOW 2 Auto Close and Save CSV file
AWESOME!!!!! THANK YOU VERY MUCH!!!!
"Alok" wrote in message ... Application.DisplayAlerts=False "WANNABE" wrote: Hi, all... I am trying to copy some values into a CSV file then close and save both files. When I use ActiveWindow.save or ActiveWindow.Close on the CSV file it prompts my if I want to save it as is, and OF COURSE I DO... How can I accomplish this with out the prompts??? Thank you again.... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Auto save and close | Excel Worksheet Functions | |||
| Auto-save on close | Excel Programming | |||
| Auto Open file VBA Refresh MS Query Save Close | Excel Programming | |||
| Auto Excel workbook close: save= false during an auto subroutine | Excel Programming | |||
| Auto Close and Save | Excel Programming | |||
Linear Mode
