CSV Generation macro not generating a .csv file
Hello!
Can you please advise what is wrong with my macro called "SaveEachWorksheet"? When running it, the generated csv files have just the csv extension in the file name, but they are somehow saved as .xlsx files, which is not the expected output....
Thank you!
Hi Beck82,
just adding an extension to the filename will not save it as CSV but stating which FileFormat you want to save like
Ciao,
Please Login or Register to view this content.
Holger
Last edited by HaHoBe; 09-15-2022 at 08:57 AM. Reason: changing ActiveWorkbook to ThisWorkbook
Use Code-Tags for showing your code: [code] Your Code here [/code]
Please mark your question Solved if there has been offered a solution that works fine for you
Hi Beck82,
if you do not include the FileFormat when using SaveAs Excel will always save the file in the format you may find at File/Options/Save. In your case that is the format xlsx/xlOpenXMLWorkbook or number 51 on Windows.
For more information about SaveAs you may have a look at Use VBA SaveAs in Excel 2007-2016, more information about the FileFormat may be found at XlFileFormat enumeration (Excel).
Ciao,
Holger
Last edited by HaHoBe; 09-15-2022 at 10:57 AM. Reason: link to site of Ron de Bruin corrected
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks