Copy Worksheets Error #1004 Work Around
Hi,
I have a workbook that has hidden sheets that I repeatedly copy and rename.
I them populate them with data from a web page. I am planning to use a
variation of the work around method from 'XL2000: Copying Worksheet
Programmatically Causes Run-Time Error 1004' - 210684.
Can I create a template from my existing workbook and place my worksheets
that I have been copying and renaming in the template. I would like to import
them back into my primary workbook and rename them.
Will I have problems with the programing, menus and buttons that are part of
those sheets?
Is there any thing special I should be concerned with importing those sheets
from the template?
Why does it have to be a template? (I don't have a centeral site to palce
the template).
Thanks,
Jim Wiley
|