Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Author

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

View solution in original post

2 Replies
Not applicable
Author

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
Author

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