Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

How to Save and Replace Excel File

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 :\

1 Solution

Accepted Solutions
Not applicable

Re: How to Save and Replace Excel File

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

2 Replies
Not applicable

Re: How to Save and Replace Excel File

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

Not applicable

Re: How to Save and Replace Excel File

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????

Community Browser