| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Retieve Workbook Name via code
Is there some code that will retrieve a workbook name?
What I'm trying to do within some code (in an xl template) is to activate the workbook again after the procedure has done some activity in another workbook. But the workbook that has the code in it doesn't always have the same name. Rob |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Retieve Workbook Name via code
Thisworkbook.Activate
"RobN" wrote: Is there some code that will retrieve a workbook name? What I'm trying to do within some code (in an xl template) is to activate the workbook again after the procedure has done some activity in another workbook. But the workbook that has the code in it doesn't always have the same name. Rob |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Retieve Workbook Name via code
Thanks JMB....so simple!
Rob "JMB" wrote in message ... Thisworkbook.Activate "RobN" wrote: Is there some code that will retrieve a workbook name? What I'm trying to do within some code (in an xl template) is to activate the workbook again after the procedure has done some activity in another workbook. But the workbook that has the code in it doesn't always have the same name. Rob |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Retieve Workbook Name via code | Excel Discussion (Misc queries) | |||
| workbook code | Excel Worksheet Functions | |||
| VBA code is being deletd from WorkBook | Excel Discussion (Misc queries) | |||
| copy and paste using code from workbook to workbook | Excel Discussion (Misc queries) | |||
| Often-Used Code not working in a new Workbook | Excel Discussion (Misc queries) | |||
![RobN[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
