Macro for exporting a table

Occasional Contributor

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