We are filling our ERP system and webshop from 1 master XL-file. All data is in 1 workbook, with one master worksheet which is filled, the other data is copied to other worksheets within the workbook.
The upload data is a part of the masterdata and content depends on usgae (ERP or WEB) Due to uoload limits, we have to split the data in smaller parts.
After every update we need to upload all files again, which means that we have to save all separate worksheets as CSV. I want to "automate" this and build a macro that takes selected worksheets and saves the contents in separate CSV files, each with a different name. The name should have a date included and if possible the name of the worksheet.
Is this possible, and how should I do this?
please suggest.
Bookmarks