Response to menu in VBA

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,
I have macros which save the file name "temp.xls" which already exists. I
want the
macro to replace the existing file without waiting for the user to input a
response.
How do I write this in VBA ?
Thanks in advance,
Rocco
 
Application.DisplayAlerts = False
ActiveWorkbook.SaveAs FileName:="temp.xls"
Application.DisplayAlerts = True

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
You must log in or register to reply here.

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

Calling subroutine defined in another workbook (autostart workbook) 5
getsaveasfilename loop... <> false and not already exists 2
Excel VBA 0
macro to copy cells from one workbook to another 1
vba powerpoint pasting named shape in selected named slides 0
Time Delayed Response to MsgBox 5
Excel SaveAs to force overwrite of extant file 1
QUERY halts VBA 3

Back
Top