
Not applicable
2015-06-16
11:32 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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?
- Tags:
- qlikview_scripting
3,443 Views
1 Solution
Accepted Solutions


Master II
2015-06-16
12:39 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Before the save command. try:
XLDOC.Application.DisplayAlerts = False;
2,910 Views
2 Replies


Master II
2015-06-16
12:39 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Before the save command. try:
XLDOC.Application.DisplayAlerts = False;
2,911 Views

Not applicable
2015-06-17
03:28 AM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thanks Mike worked a dream
2,910 Views
