I have a macro that I intend to loop, but it's creates a CSV file at the end. Because I have to do a "Save As", it replaces my open .xlsm file with the newly saved .csv version.. Is there a way to prevent Excel from opening the CSV and continue through the loop?
Bookmarks