Forum Discussion
Macro for exporting a table
Is it possible to export a specific table as a new workbook and save it? If so how can this be done? How can I create a button when the user pushes, it prompts user to give it a name and save it in ...
Hi Nikolino,
Many thanks for the help. It seems very promissing but the exported file didn't have any file extnesions so it wouldn't open. Secondly, I want to be able to export a specific table in the sheet. When I export, it needs open the save as dialog box and the name should be the fileName_todaysDate, is tere a way to do that?
Many thanks for the help. It seems very promissing but the exported file didn't have any file extnesions so it wouldn't open. Secondly, I want to be able to export a specific table in the sheet. When I export, it needs open the save as dialog box and the name should be the fileName_todaysDate, is tere a way to do that?
I can't offer tailor-made solutions due to time constraints, but here's an approach - create a link with the option to do it yourself.
How to save a selection as individual file in Excel?
Thank you for your understanding and patience