When Wanting To Replace Previously Saved .xls File

  • Thread starter Thread starter Chuckles123
  • Start date Start date
C

Chuckles123

Is there any way to do this in VBA code so that the user is not prompte
with the 'Replace?' Question?

Thanks for a response,
Chuckles12
 
Hi Chuckles123,
Is there any way to do this in VBA code so that the user is not prompted
with the 'Replace?' Question?
Click to expand...

Yes, put:

Application.DisplayAlerts = False

before the Save As, and

Application.DisplayAlerts = True

after it.

Regards

Stephen Bullen
Microsoft MVP - Excel
www.oaltd.co.uk
 
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

Archive Attribute Excel 2003 3
MsgBox Replacement w/ an UserForm 1
SAVE A SHEET AS A BOOK, CLOSE IT, CONTINUE VBA CODE - XCL 2003 16
XLT vs XLS 8
Replacing XLS file rather than saving 3
xlsm SaveAs xls 4
User Input Of A Number 1
XLSM to XLS conversion 1

Back
Top