View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jim Wiley Jim Wiley is offline
external usenet poster
 
Posts: 1
Default 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