Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 😕
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
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
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????