topic Re: How to Save and Replace Excel File in QlikView

How to Save and Replace Excel File

Mon, 08 Oct 2012 08:40:25 GMT

Hi ppl How can i save and replace a file ?

My code

Application.DisplayAlerts = False

...

XLSheet.SaveAs"C:\TestXLS.xlsx"

set XLApp = Nothing

set XLDOC = Nothing

set XLSheet = Nothing

Application.DisplayAlerts=True

when i try this wait..only open the edit module... when i remove application.DisplayAlerts...ask me if i want to replace the file 😕

Re: How to Save and Replace Excel File

Mon, 08 Oct 2012 10:32:35 GMT

Hi ppl problem solved

XLApp.DisplayAlerts = False

...

XLSheet.SaveAs"C:\TestXLS.xlsx"

XLApp.Quit

set XLApp = Nothing

set XLDOC = Nothing

set XLSheet = Nothing

XLApp.DisplayAlerts=True

Re: How to Save and Replace Excel File

Thu, 16 May 2013 17:21:52 GMT

Hi nuno,

I need to create a form, where people can fill it out, and then save it, and it goes to an excel file, but not replace it, just keep adding the answers... Could you help me doing it somehow????