Copy ALL worksheets (values and formats only) to new workbook

[Tomkat]

I have searched for a solution, but have only found ones that do a simple "convert cells to values, then save workbook as new name" solution... this will not work for me, as my workbook has database connections (queries), as well as links.

I need the "New Workbook" to be VALUES ONLY, and free of all database connections and links...

Therefore, I believe what I am trying to do is this...

*THIS IS NOT ACTUAL CODE, just the CONCEPT of what I need to do...

Please Login or Register  to view this content.

However, I am unsure of the actual syntax of how to accomplish this.

I have the general IDEA, I just can't find the bits of code I need to piece together.

Can anyone please help me?

[arlu1201]

Try this code

Please Login or Register  to view this content.