Hi All,
I have a need to copy sheet called Lookup from an Open workbook which is a macro enabled worksheet to a Macro Enabled Template called Buylist V2.xltm.
Both the Open workbook and the Closed Template are in the same folder. I use
to get the folder information.
There is already a sheet called Lookup in the Closed Template.
Sheet Lookup in the closed workbook should be replaced with the one from the Open workbook and the Template saved with the same filename (i.e. Buylist V2.xltm).
Please note that there are formulas in the closed workbook that use sheet called Lookup, and these formulas should not be affected.
I have a need to copy sheet called Lookup from an Open workbook which is a macro enabled worksheet to a Macro Enabled Template called Buylist V2.xltm.
Both the Open workbook and the Closed Template are in the same folder. I use
VBA Code:
fPath = ThisWorkbook.Path & "\"
There is already a sheet called Lookup in the Closed Template.
Sheet Lookup in the closed workbook should be replaced with the one from the Open workbook and the Template saved with the same filename (i.e. Buylist V2.xltm).
Please note that there are formulas in the closed workbook that use sheet called Lookup, and these formulas should not be affected.