Save and Replace in VB Script

Tue, 16 Jun 2015 15:32:08 GMT

Hi Guys,

Using VB Script I am trying to save an excel file out of Qlikview ending with the following:

XLSheet1.SaveAs "C:\Users\User\Test_Output.xlsx"

XLDOC.Application.Quit

The doc 'Test_Output.xlsx' already exists so I am essentially trying to replace it and close the document with no user interaction. However every time I run this script the excel prompts the attached dialog to confirm the user wishes to replace the file.

Is there a VB function to essentially save and replace without this prompt?

Re: Save and Replace in VB Script

m_woolf — Tue, 16 Jun 2015 16:39:16 GMT

Before the save command. try:

XLDOC.Application.DisplayAlerts = False;

Re: Save and Replace in VB Script

Wed, 17 Jun 2015 07:28:10 GMT

Thanks Mike worked a dream

topic Save and Replace in VB Script in QlikView

Save and Replace in VB Script

Re: Save and Replace in VB Script

Re: Save and Replace in VB Script