Saving a workbook with VBA..... - Xtreme Visual Basic Talk

11-01-2004, 05:25 AM

KnooKie

Senior Contributor

Join Date: May 2003

Location: London

Posts: 802

Saving a workbook with VBA.....

i am wanting to save a workbook which i can do fine but the part i am having trouble with is if the workbook already exists. If it does exist i want to overwrite it without the popup 'Do you want to overwrite' message coming up.

i thought the following might work but the popup still seems to appear.....

Code:

Set xlWb = XLapp.Workbooks.Add
xlWb.SaveAs FileName:=FileLocation & DirName & (Left(DirName, Len(DirName) - 1)), ConflictResolution:=xlLocalSessionChanges

any ideas please

11-01-2004, 06:07 AM

Greychild

Centurion

Join Date: Jan 2004

Location: Hong Kong

Posts: 176

What you need is

Code:

Application.DisplayAlerts = False
'Code to save file
Application.DisplayAlerts = True

Don't forget to set the DisplayAlerts back to true, or you won't get warning messages prompting you to save Excel files as you close them. That can be VERY annoying, as a lot of people rely on that message.

Posting Rules

You may not post new threads

You may not post replies

You may not post attachments

You may not edit your posts

BB code is On

Smilies are On

[IMG] code is Off

HTML code is Off

Forum Rules