View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
John[_115_] John[_115_] is offline
external usenet poster
 
Posts: 7
Default How do I create a new worksheet using a template or xls file

I have a formatted excel file with cell formatting plus an inserted bitmap
logo.

Can I add a worksheet using that file as a template?

VBA help says "If you are inserting a sheet based on an existing template,
specify the path to the template. The default value is xlWorksheet."

So is this valid?...

Set newsheet = MasterWorkBook.Worksheets.Add(Type:="C:\Program Files\Bourret
Tools\_POTemplate.xlt")

It doesn't work!

newsheet is still nothing after this line