View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Peter T Peter T is offline
external usenet poster
 
Posts: 5,600
Default Workbooks.Add question

I thought
Workbooks.Add created a new workbook.


It does. If you add a valid filename that'll open as a template.

In passing, although + works to concatenate strings best to use &. In some
scenarios not the same.


Regards,
Peter T

"Barb Reinhardt" <Barb wrote in message
...
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