The Add method takes as an optional parameter a Template file name. If
this is supplied, it uses that file as a template. For example,
Workbooks.Add
just opens a new workbook (based on Book.xlt if that exists in the
XLStart directory).
Workbooks.Add "C:\Book1.xls"
opens a new workbook based on C:\Book1.xls. You'll notice that a "1"
is appended to the file name, so the file open in Excel would be
C:\Book11.xls.
Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group, 1998 - 2009
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)
On Thu, 19 Mar 2009 12:24:00 -0700, Barb Reinhardt <Barb
wrote:
I have the following line of code in a workbook that I'm working on.
Workbooks.Add ThisWorkbook.Path + "\" + "MyTempWrkSht.xls"
when I get to this line, it opens the workbook that's listed. I thought
Workbooks.Add created a new workbook. Can someone please help me with my
confusion.
Thanks,
Barb Reinhardt