| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
add a workbook.
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? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
add a workbook.
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? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
add a workbook.
I add a workbook and name it but not save it and I can
find it in my C drive without saving it? -----Original Message----- 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? . |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
add a workbook.
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) wrote in message ... I add a workbook and name it but not save it and I can find it in my C drive without saving it? -----Original Message----- 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? . |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
add a workbook.
You can't name it without saving it. The saved file name is the name of the
workbook. -- Regards, Tom Ogilvy wrote in message ... I add a workbook and name it but not save it and I can find it in my C drive without saving it? -----Original Message----- 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? . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel-how to link source workbook to copy of destination workbook | Excel Worksheet Functions | |||
| Select sheet tabs in workbook & save to separate workbook files | Excel Worksheet Functions | |||
| Copy a range of cells in an unopened workbook and paste it to the current workbook | Excel Programming | |||
| Open a password protected excel workbook from second workbook to fetch data using dynamic connection | Excel Programming | |||
| What commands do you use to name a workbook, save a workbook,open a workbook | Excel Programming | |||
![Joe User[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
