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

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