Give multiple worksheets in workbook, export specific worksheet (CSV) while
converting to CSV file, removing column header and adding an empty line at the beginning.
Using this code right now, which exports the active worksheet, does the conversion,
etc, but in this case, I have to be in the CSV worksheet for it to function properly.
I'd like to export CSV automatically without needing to be in.
I tried setting a few variables and exporting but obviously Im still too much
of a novice.
UPDATE: After multiple hours of research and testing, most of which gave me various fun errors, I found the solution and added a line just below the Sub identifier and above the Private Sub
Moderator's note: Please take the time to review our rules. There aren't many, and they are all important. Rule #3 requires code tags. I have added them for you this time because you are a new member. --6StringJazzer
Bookmarks