| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Workbooks.Add question
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Workbooks.Add question
I thought
Workbooks.Add created a new workbook. It does. If you add a valid filename that'll open as a template. In passing, although + works to concatenate strings best to use &. In some scenarios not the same. Regards, Peter T "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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Workbooks.Add question
The Add method takes as an optional parameter a Template file name. If this is supplied, it uses that file as a template. For example, Workbooks.Add just opens a new workbook (based on Book.xlt if that exists in the XLStart directory). Workbooks.Add "C:\Book1.xls" opens a new workbook based on C:\Book1.xls. You'll notice that a "1" is appended to the file name, so the file open in Excel would be C:\Book11.xls. Cordially, Chip Pearson Microsoft Most Valuable Professional Excel Product Group, 1998 - 2009 Pearson Software Consulting, LLC www.cpearson.com (email on web site) On Thu, 19 Mar 2009 12:24:00 -0700, Barb Reinhardt <Barb wrote: 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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Workbooks.Add question
Just a typo...
The workbook that was created wouldn't have the extension (or path). It would just be named: Book11 Chip Pearson wrote: The Add method takes as an optional parameter a Template file name. If this is supplied, it uses that file as a template. For example, Workbooks.Add just opens a new workbook (based on Book.xlt if that exists in the XLStart directory). Workbooks.Add "C:\Book1.xls" opens a new workbook based on C:\Book1.xls. You'll notice that a "1" is appended to the file name, so the file open in Excel would be C:\Book11.xls. Cordially, Chip Pearson Microsoft Most Valuable Professional Excel Product Group, 1998 - 2009 Pearson Software Consulting, LLC www.cpearson.com (email on web site) On Thu, 19 Mar 2009 12:24:00 -0700, Barb Reinhardt <Barb wrote: 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 -- Dave Peterson |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Workbooks.Add question
As usual, you're right. Cordially, Chip Pearson Microsoft Most Valuable Professional Excel Product Group, 1998 - 2009 Pearson Software Consulting, LLC www.cpearson.com (email on web site) On Thu, 19 Mar 2009 16:52:58 -0500, Dave Peterson wrote: Just a typo... The workbook that was created wouldn't have the extension (or path). It would just be named: Book11 Chip Pearson wrote: The Add method takes as an optional parameter a Template file name. If this is supplied, it uses that file as a template. For example, Workbooks.Add just opens a new workbook (based on Book.xlt if that exists in the XLStart directory). Workbooks.Add "C:\Book1.xls" opens a new workbook based on C:\Book1.xls. You'll notice that a "1" is appended to the file name, so the file open in Excel would be C:\Book11.xls. Cordially, Chip Pearson Microsoft Most Valuable Professional Excel Product Group, 1998 - 2009 Pearson Software Consulting, LLC www.cpearson.com (email on web site) On Thu, 19 Mar 2009 12:24:00 -0700, Barb Reinhardt <Barb wrote: 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 |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Workbooks.Add question
I'll take the easy questions!
Chip Pearson wrote: As usual, you're right. Cordially, Chip Pearson Microsoft Most Valuable Professional Excel Product Group, 1998 - 2009 Pearson Software Consulting, LLC www.cpearson.com (email on web site) On Thu, 19 Mar 2009 16:52:58 -0500, Dave Peterson wrote: Just a typo... The workbook that was created wouldn't have the extension (or path). It would just be named: Book11 Chip Pearson wrote: The Add method takes as an optional parameter a Template file name. If this is supplied, it uses that file as a template. For example, Workbooks.Add just opens a new workbook (based on Book.xlt if that exists in the XLStart directory). Workbooks.Add "C:\Book1.xls" opens a new workbook based on C:\Book1.xls. You'll notice that a "1" is appended to the file name, so the file open in Excel would be C:\Book11.xls. Cordially, Chip Pearson Microsoft Most Valuable Professional Excel Product Group, 1998 - 2009 Pearson Software Consulting, LLC www.cpearson.com (email on web site) On Thu, 19 Mar 2009 12:24:00 -0700, Barb Reinhardt <Barb wrote: 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 -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sharing workbooks question | Excel Discussion (Misc queries) | |||
| Linking to other workbooks question | Excel Discussion (Misc queries) | |||
| Question : Workbooks or Worksheets? | Excel Worksheet Functions | |||
| Multiple workbooks question | Excel Discussion (Misc queries) | |||
| One formula on multiple workbooks question | Excel Discussion (Misc queries) | |||
Linear Mode
