Thread
:
Workbooks.Add question
View Single Post
#
3
Posted to microsoft.public.excel.programming
Peter T
external usenet poster
Posts: 5,600
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
Reply With Quote
Peter T
View Public Profile
Find all posts by Peter T