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
|