Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Save and Replace in VB Script

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?

1 Solution

Accepted Solutions
mwoolf
Honored Contributor II

Re: Save and Replace in VB Script

Before the save command. try:

XLDOC.Application.DisplayAlerts = False;

2 Replies
mwoolf
Honored Contributor II

Re: Save and Replace in VB Script

Before the save command. try:

XLDOC.Application.DisplayAlerts = False;

Not applicable

Re: Save and Replace in VB Script

Thanks Mike worked a dream

Community Browser