2 Replies Latest reply: Jun 17, 2015 3:28 AM by Carly McClintock RSS

    Save and Replace in VB Script

    Carly McClintock

      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?