View Single Post
  #1   Report Post  
JohnUK
 
Posts: n/a
Default Changing Defaults in VBA 2

I need a code that opens a workbook, and then saves it as
another workbook that already exists, without it telling
me, the file already exists, do you want to replace it?
I just want it to do it without it asking me.
When you want this done on a dozen workbooks, it gets a
bit tedious keep pressing the yes button, when everything
else runs through smoothly via code.
Many thanks in advance
John