VBA - using save as without opening the file and desactivate alerts

[PaulaGon]

Hello,

In this forum I found a solution to create a code to export a table and save it as a CVS file:
(https://www.excelforum.com/excel-pro...ml#post5016460)

The code export a table and activates the save as dialog box for the user choose the destination where it wants to save the file. The problem is that after saving the file, the user always need to close the file that was open in the middle of the process, and also a dialog box appears asking the user if he wants to save the changes in the file.
Is there any way to just save the cvs file without opening the files and avoid the dialog box alerts at the end of the process?

I attached the file with the example.

Any suggestions would be greatly appreciated!

Thank you in advance

[Richard Buttrey]

Hi,

Just put

awb.Close

before

Application.DisplayAlerts = True

[PaulaGon]

Hello Richard,

I put "awb.Close" before "Application.DisplayAlerts = True" and at the beginning seemed to work well but when I open the cvs file, that I saved, all the data appear in the first column separate by commas. I need to save the data in a cvs file but delimited in three columns (Customer ID, Revenue, ID SalesPerson).
I made a test with my first vba code and after closing the cvs file, it appears always a dialog box asking if “I wish to save the changes in the cvs file”: if I choose “yes” when I open the cvs file that I saved, the data is delimited in three columns, if I choose “no” when I open the cvs file the data appear all in the first column…


Kind regards

[Richard Buttrey]

...maybe the following

Please Login or Register  to view this content.