View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Barb Reinhardt Barb Reinhardt is offline
external usenet poster
 
Posts: 4
Default Workbooks.Add question

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