G
Guest
Here is my goal. Part 1, I want to have a program to open an Excel template that uses macros to access data from multiple files and format the information. This part was accomplished.
Part 2, I want to save this file under a different name as a .XLS file withouth the macros (data only) while keeping the Excel Template intact for future use.
It is part 2 that I need assistance.
Please be as explicit as possible in your response.
Thanks!
Joe
P.S. I had seen a previous question regarding saving Excel where a macro deletes all the macros. It referred to http://www.cpearson.com/excel/vbe.htm
I received some error messages - Compile errors: User defined type not defined for "Dim VBComp As VBIDE.VBComponent"
I am a novice from a VB perspective - haven't written any serious code in over 10 years so assume I forgot everything.
Part 2, I want to save this file under a different name as a .XLS file withouth the macros (data only) while keeping the Excel Template intact for future use.
It is part 2 that I need assistance.
Please be as explicit as possible in your response.
Thanks!
Joe
P.S. I had seen a previous question regarding saving Excel where a macro deletes all the macros. It referred to http://www.cpearson.com/excel/vbe.htm
I received some error messages - Compile errors: User defined type not defined for "Dim VBComp As VBIDE.VBComponent"
I am a novice from a VB perspective - haven't written any serious code in over 10 years so assume I forgot everything.