add a workbook.

J

Joe User

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?
 
B

Bob Phillips

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)
 
G

Guest

I add a workbook and name it but not save it and I can
find it in my C drive without saving it?
 
B

Bob Phillips

No, it isn't there until the first time it is saved.

--

HTH

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

Tom Ogilvy

You can't name it without saving it. The saved file name is the name of the
workbook.
 
Top