how to If the button is clicked by the user, then the active sheet should be saved as a new workbook with the naming convention: SheetName_(CustomerNo_DD.MM.YYYY) ?
how to If the button is clicked by the user, then the active sheet should be saved as a new workbook with the naming convention: SheetName_(CustomerNo_DD.MM.YYYY) ?
this is basically what you should do. You just have to change the folder path and sheet name.
Please Login or Register to view this content.
Pierre Leclerc
_______________________________________________________
If you like the help you got,
Click on the STAR "Add reputation" icon at the bottom.
Awesome thanks!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks