Thread: Automatic replacing a file while in a macro
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
JasperBlaas[_3_] JasperBlaas[_3_] is offline
external usenet poster
  
Posts: 1
Default Automatic replacing a file while in a macro

I have a macro that, among other things, saves a worksheet with a
specific name. Everytime the macro is run I get the standard dialog box
"do you want to replace the existing file". I am looking for away to
replace the file without the dialog box popping up, so the user won't
have to interfere.

Thanks in advance,

Jasper Blaas


--
JasperBlaas
------------------------------------------------------------------------
JasperBlaas's Profile: http://www.excelforum.com/member.php...o&userid=12615
View this thread: http://www.excelforum.com/showthread...hreadid=400776

Reply With QuoteReply With Quote