How do I : Import Sheet from Template Excel Workbook? (VBA)

Hi!
Anyone who tries to help me fix this issue, I greatly appreciate it.
It's something that I haven't been able to google, and the only other option I've thought of is directly editing the xml files and importing the sheet!

The background of this;
I want to have the user pull the latest revision of sheets from the main template file.
I recorded a macro using the macro recorder (redundant) and used that skeleton to get me what I wanted.
I searched all over for any type of object oriented method of doing this but was unable to get anything to work correctly!

Here is the code I am currently using which causes me to also have to reopen the excel workbook because it causes some sort of break, which excel warns me that the file is damaged and could only save a little bit.

Please Login or Register  to view this content.

Bonus Question: How do I stop the references from being attached to the template workbook and instead to the active workbook when using .copy? (Easy suggestions: program all the formulas into the macro? --- That makes it harder for non-VBA users to edit changes, however. ;'( )

Thanks for your time.

use a sub not a function.

Please Login or Register  to view this content.