I have a macro that will parse data and save it as a csv. Unfortunately, since I save it as a csv, it leaves a trail of commas in the file for any row that does not reach all of the headers so I have to manually open the file and backspace out all of the trailing commas.
Is there a simple macro that could basically append the file that gets saved and eliminate commas that are located at the end of the line?
Bookmarks