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.


Please Login or Register  to view this content.