Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

stop excel asking me if i want to overwrite existing file

Status
Not open for further replies.
simeybt

simeybt

Programmer
Nov 3, 2003
147
GB
All,
I’m trying to SaveAs a file in the same location it is currently saved with the same file name. I want to be able to overwrite the existing file without excel asking if I want to overwrite the file

simey
 
Sort by date Sort by votes
application.displayalerts=false
(set it back to true right afterwards!)


Rob
[flowerface]
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

JAB_123
  • Locked
  • Question
I want to use an excel file for inp
Replies
3
Views
402
dhookom
dhookom
remeng
  • Locked
  • Solved
Run-time error '429': ActiveX component can't create object From Excel to Word
Replies
9
Views
1K
remeng
remeng
remeng
  • Locked
  • Question
Excel VBA to Pass Var between file macros after var changes
Replies
13
Views
672
mikrom
mikrom
remeng
  • Locked
  • Question
If obsolete - deactivate all but one macro
Replies
6
Views
448
mintjulep
M
feipezi
  • Locked
  • Question
How to make a recorded Excel macro (convert a text file to a Workbook) more efficient?
Replies
11
Views
644
SkipVought
S

Part and Inventory Search

Sponsor

Back
Top