I have a button that runs a macro, but it isn't working. When I click the button, i am trying to save Sheet2 as filename "Import.csv" in the "C:\ToImport" folder. So the steps I manually take are:
1. Click on Sheet2
2. File>Save As>"Import.csv"
I would like to keep my original .mxlsx spreadsheet open so I can do more with it. Any help writing this macro would be appreciated! Thanks!