Hello - I am trying to save specific cells from one workbook into another workbook with the click of a command button.
I would like to save a specific dynamic area into a new workbook, I have created a new object name for this dynamic table as "Template_Table", so this is the area that needs to be saved into a new workbook ---- I do not know how to implement his part in my code below, any suggestions?
I would like a dialog to popup to ask the use what they would like to name the new workbook when they click the command button, is this possible?
I have the code below thus far, but I have an "Run Time 1004, Application Defined or Object Defined Error" -- Any idea what is going on? And how I can fix this?
Thank you for your help.
Bookmarks