Auto save overwriting original copy

  • Thread starter Thread starter Mikey May
  • Start date Start date
M

Mikey May

Thanks to Jim Rech for solving my problem a couple of days
ago.

Another problem I have now is automatically overwiting a
file without Excel asking if i want to overwite the
original file

Range("R8").Select
If ActiveCell = 0 Then
Workbooks("CTS Master").Close False
Exit Sub
Else
Rountine1
ActiveWorkbook.SaveAs "p:\Test Folder\Amanda_
Dunnell\CTS Master.xls"
Workbooks("CTS Master").Close False

When cell R8 has a value of 0 this will work and close
without saving or any prompts, but if R8 does not have a
value of 0 then the macro runs Routine1 and needs to
overwrite original version of 'CTS Master'. Don't know
how to overwrite without any prompts.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

save & backup file 2
VBA to Move Sheets and save 3
VBA - Do Loop or SaveChanges = false 1
Copy worksheets and save files dynamically 3
Save as, not overwrite 1
Forcing SaveAs to overwrite 1
User defined file name on save 11
Save using a Macro 6

Back
Top