My process is to copy information from Google spreadsheets created by other offices onto an Excel Spreadsheet. I save as CSV to upload into our software. I only need to do this the first time then each subsequent time, I just save. I may have to do this 20 times in a row. Our software made changes the other day. Now I get an error that it won't upload because file is still open in another program. I need to somehow save as CSV but leave my original .xls file open. I tried save copy as but just read it won't work because the file extension cannot be changed. It would be too time consuming to save as then close then reopen then save as repeatedly.
Note that my Excel file as two tabs: REPLENISH 2020: formatted to copy directly from the google sheets and has other formulas. JE UPLOAD 20 is the second tab with links to REPLENISH 2020 to be in the layout required by our software.
Is there a macro that will save as CSV but leave the XLS open?
Thank you
Note that my Excel file as two tabs: REPLENISH 2020: formatted to copy directly from the google sheets and has other formulas. JE UPLOAD 20 is the second tab with links to REPLENISH 2020 to be in the layout required by our software.
Is there a macro that will save as CSV but leave the XLS open?
Thank you