Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Save messages
Hi everyone, I made a macro to extract report from a big file, this macro then saves it to a file called "today.csv" which already exist. Is there a way save the file without having the popup about the file already exist and do you want to continue? Thanks in advance. -- ledzepe ------------------------------------------------------------------------ ledzepe's Profile: http://www.excelforum.com/member.php...o&userid=25207 View this thread: http://www.excelforum.com/showthread...hreadid=568090 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Save messages
Put in a line that reads
Application.DisplayAlerts = False before your save instruction "ledzepe" wrote: Hi everyone, I made a macro to extract report from a big file, this macro then saves it to a file called "today.csv" which already exist. Is there a way save the file without having the popup about the file already exist and do you want to continue? Thanks in advance. -- ledzepe ------------------------------------------------------------------------ ledzepe's Profile: http://www.excelforum.com/member.php...o&userid=25207 View this thread: http://www.excelforum.com/showthread...hreadid=568090 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cannot save excel files to a folder on a network | Excel Discussion (Misc queries) | |||
I get error messages in Excel cells once I save a file | Excel Worksheet Functions | |||
macro save a workbook whilst increasing file no | Excel Worksheet Functions | |||
Save as Msg box | Excel Discussion (Misc queries) | |||
Save & Save As features in file menu of Excel | Excel Discussion (Misc queries) |