Is it possible to use this PDF macro to create a new Excel file the same way?

Hi,

I use a macro to create/save a PDF file to my computer and it works great. Is there a way to change this code or another code that will do the same thing except create/save a new Excel workbook with the same data? I have a large workbook and sometimes I need to take specific data from it and enter it into a new workbook sheet. As of now, I have to create the new workbook, copy the data and then paste it to the new workbook. It would be great if I could just click a macro button that then creates a new workbook with the specific data in it... just like the macro does with a PDF file. Is this possible?

Here is the PDF macro code I use...

Please Login or Register  to view this content.

.
This is one of many methods :

Please Login or Register  to view this content.

Hi Logit,

Thanks so much... it's almost perfect. The only thing I'm trying to figure out is how to only paste the values that are copied and not the format with it. I tried to change paste to the paste special code but get a run time error.

Any ideas on how to change it so it only pastes the values?

Figured it out! Thank you again Logit!

.

Please Login or Register  to view this content.

I just did this and it seems to work. Should I change it to your new code above?

Please Login or Register  to view this content.

.
If your macro works .. then it is good.