Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Route for new workbook
Dear all,
I'm in process of create new workbook via VBA, did like this: Set wb = Workbooks.Add(1) But I was confused what is the route of my new workbook, and if I want to assign a pre-defined route, how to do? Could you give any sign? Thanks, Viesta |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Route for new workbook
Viesta,
What do you mean by "route" ? NickHK "ViestaWu" wrote in message ... Dear all, I'm in process of create new workbook via VBA, did like this: Set wb = Workbooks.Add(1) But I was confused what is the route of my new workbook, and if I want to assign a pre-defined route, how to do? Could you give any sign? Thanks, Viesta |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Route for new workbook
file path, I mean.
"NickHK" wrote: Viesta, What do you mean by "route" ? NickHK "ViestaWu" wrote in message ... Dear all, I'm in process of create new workbook via VBA, did like this: Set wb = Workbooks.Add(1) But I was confused what is the route of my new workbook, and if I want to assign a pre-defined route, how to do? Could you give any sign? Thanks, Viesta |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Route for new workbook
Viesta,
If you have just added a new WB, the need to .Save it give it a path. eg. Dim WB As Workbook Set WB=Workbooks.Add(1) WB.Save PathAndFilename NickHK "ViestaWu" wrote in message ... file path, I mean. "NickHK" wrote: Viesta, What do you mean by "route" ? NickHK "ViestaWu" wrote in message ... Dear all, I'm in process of create new workbook via VBA, did like this: Set wb = Workbooks.Add(1) But I was confused what is the route of my new workbook, and if I want to assign a pre-defined route, how to do? Could you give any sign? Thanks, Viesta |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Route for new workbook
I believe it does make sense. and I will take try after reading the Saveas
method in Help Files. BTW, is sheets.add in the same case? Thanks so much Nick! "NickHK" wrote: Viesta, If you have just added a new WB, the need to .Save it give it a path. eg. Dim WB As Workbook Set WB=Workbooks.Add(1) WB.Save PathAndFilename NickHK "ViestaWu" wrote in message ... file path, I mean. "NickHK" wrote: Viesta, What do you mean by "route" ? NickHK "ViestaWu" wrote in message ... Dear all, I'm in process of create new workbook via VBA, did like this: Set wb = Workbooks.Add(1) But I was confused what is the route of my new workbook, and if I want to assign a pre-defined route, how to do? Could you give any sign? Thanks, Viesta |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Route for new workbook
Viesta,
Sheets.Add is not the same, as a sheet does have a path; the WB that contains it does. NickHK "ViestaWu" wrote in message ... I believe it does make sense. and I will take try after reading the Saveas method in Help Files. BTW, is sheets.add in the same case? Thanks so much Nick! "NickHK" wrote: Viesta, If you have just added a new WB, the need to .Save it give it a path. eg. Dim WB As Workbook Set WB=Workbooks.Add(1) WB.Save PathAndFilename NickHK "ViestaWu" wrote in message ... file path, I mean. "NickHK" wrote: Viesta, What do you mean by "route" ? NickHK "ViestaWu" wrote in message ... Dear all, I'm in process of create new workbook via VBA, did like this: Set wb = Workbooks.Add(1) But I was confused what is the route of my new workbook, and if I want to assign a pre-defined route, how to do? Could you give any sign? Thanks, Viesta |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I route an excel workbook to a series of e-mail recipients | Excel Discussion (Misc queries) | |||
How do I route a spreadsheet? | Excel Discussion (Misc queries) | |||
how to delete duplicate file example route 2_2:1 or route 2_2:2 | Excel Discussion (Misc queries) | |||
When set to route, route with on open worksheet...not the hidden o | Excel Programming | |||
Minimum route from two nodes | Excel Programming |