| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
refer to unknown window name
Im writing a code for a workbook which will freqently be copied and renamed.
In part of the code for this workbook it goes outside the workbook and then has to reselect it Windows("????????").Activate How can I get it to know the name of the workbook the code is in? Thanks, Ciara |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
refer to unknown window name
Ciao,
try Thisworkbook.activate |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
refer to unknown window name
but the thing is i go out of the workbook - into another excel file - and
then go back into the orignal one - but i dont' know the originals name! "Roman" wrote: Ciao, try Thisworkbook.activate |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
refer to unknown window name
What do you mean by "going out"? If it is just "activate" then
Thisworkbook should be OK. As I know Thisworkbook means the workbook the code is running from no matter what and where it is doing. |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
refer to unknown window name
you are absolutely right - sorry got a bit confused - thanks!
"Roman" wrote: What do you mean by "going out"? If it is just "activate" then Thisworkbook should be OK. As I know Thisworkbook means the workbook the code is running from no matter what and where it is doing. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to save a desired window size but hv window comeup fullsz by d | Excel Discussion (Misc queries) | |||
| View cell contents as a pop-up window (similar to comments window) | Excel Worksheet Functions | |||
| Docking Project Explorer, Properties window and Code window in VBE | Setting up and Configuration of Excel | |||
| The window opens in a smaller window not full sized window. | Excel Discussion (Misc queries) | |||
| In Excel - how to delete new window created from window on tool ba | Excel Worksheet Functions | |||
![Ciara[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
