overwrite existing file excel vba

Question

open_book.SaveAs Filename:="E:\MF\data\" & com_tick_ask & ".xlsx", FileFormat:=xlOpenXMLWorkbook, CreateBackup:=False

This is my code to save a file as xlsx but I want to overwrite an existing file. and close this workbook. Can anyone help...

Sanjeev Shinde · Accepted Answer · 2016-04-11 07:25:12Z

3

Sorry friends for trouble. I got an answer.

I just have to put this line of code immediately before my SaveAs statement...

Application.DisplayAlerts = False

and have to put this line of code immediately after it...

Application.DisplayAlerts = True

e.g.

Application.DisplayAlerts = False
open_book.SaveAs Filename:="E:\MF\data\" & com_tick_ask & ".xlsx", FileFormat:=xlOpenXMLWorkbook, CreateBackup:=False
Application.DisplayAlerts = True

answered Apr 11, 2016 at 7:25

Sanjeev Shinde

591 gold badge3 silver badges14 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

overwrite existing file excel vba

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related