Save Single Sheet from multiple sheet workbook as MSDOS CSV format

Sorry for the error posting my code. Should be formatted correctly now. Thanks to protonLeaH for the heads up!!!

Perfect!!! Worked on the first try. Thanks Mike!

Thought I was good but am still running into problems. Some of the files work fine, some return odd errors recognizing and mapping the data when I try to import into our ERP. I've noticed two things. If I manually open the csv created by this script and save as MSDOS csv over top of the original, I can import the file w/o errors. I can also open the csv in notepad and save as unicode. Both of those options work but I can't have these extra manual steps at the end. Only other option I know of (but I don't know how to achieve this) is to have all fields wrapped with quotes in the csv file. I was told that would eliminate the random issues we encounter importing the csv files. Don't know if what I described gives any clues to a solution but I greatly appreciate any ideas if you have them. Thanks!!!

OK, found the issue viewing the file in Notepad. In Notepad, I can see the last row of the csv (appears to be blank in Excel) has a row of commas. When I "save as" over top of the original, that of commas row goes away and the import file works perfectly. So it looks like what I need is to add in the script before it saves a closes, code to delete the last blank row. Is this something reasonable to add?

Originally Posted by BBen

Thought I was good but am still running into problems. Some of the files work fine, some return odd errors recognizing and mapping the data when I try to import into our ERP. I've noticed two things. If I manually open the csv created by this script and save as MSDOS csv over top of the original, I can import the file w/o errors. I can also open the csv in notepad and save as unicode. Both of those options work but I can't have these extra manual steps at the end. Only other option I know of (but I don't know how to achieve this) is to have all fields wrapped with quotes in the csv file. I was told that would eliminate the random issues we encounter importing the csv files. Don't know if what I described gives any clues to a solution but I greatly appreciate any ideas if you have them. Thanks!!!

Hi Mike - I tried that but still same issue. What I did do is take out the .close SaveChanges line so the new file stays open. I then manually deleted the last blank line saved and closed. That gets rid of the last row of extra commas and the file works correctly.

So it seems to me, if there is a way to add a line of code in your script to find the last blank row and delete the entire row before .close SaveChanges=True I would be good to go. Any thoughts?