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 a folder?
3 Replies
Here is a small VBA example...maybe it will help you.
Hope I was able to help you with this info.
I know I don't know anything (Socrates)
- 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?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
