Hi,
I have a spreadsheet with one main worksheet for time entry.
In the same workbook I have 3 other worksheets with information based on the time entry worksheet.
These 3 sheets are formatted i such a way that they can be exported to CSV files, that can be used for upload in our ERP software.
What I would like to have is a button that users can press after time entry, that will automatically create the 3 CSV files.
I did some tests for this but my problem is that, when pressing this button, the required CSV files are created but I somehow have renamed my Excel sheet with the last CSV file's name.
Is there a way to avoid this?
Thank you for your help.
I'm working with Excel 2007 and used the following code:
Bookmarks