According the the help files, the Add Method for a Workbook Object...

"Creates a new workbook. The new workbook becomes the active workbook."

--
Rick (MVP - Excel)


"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