When you add a workbook it doesn't have a path. That gets assigned when you
save it.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Joe User" wrote in message
...
I declared a workbook and set that workbook to
workbooks.add. What is the default path that workbook is
given? Can I set the path for it?