Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to set workbook window active
I have an add in that i have installed with all my macros in it. In one of my
macros i call it to open another workbook for a vlookup. i then want to continue with the previous workbook but i dont know how to return the focus to that workbook. add in: macros.xla file opened: opened.xls (name is variable!) call to open: master list.xls I cant do Thisworkbook.active because i am running out of the add-in. i cant do windows(opened.xls).active because i wont know the file name. What can i do? Thanks. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to set workbook window active
On Nov 26, 1:21 pm, Daniel M
wrote: I have an add in that i have installed with all my macros in it. In one of my macros i call it to open another workbook for a vlookup. i then want to continue with the previous workbook but i dont know how to return the focus to that workbook. add in: macros.xla file opened: opened.xls (name is variable!) call to open: master list.xls I cant do Thisworkbook.active because i am running out of the add-in. i cant do windows(opened.xls).active because i wont know the file name. What can i do? Thanks. you could store the recent workbook before opening the opened.xls and then restore it again: '---------------------------------------------------------- dim Curr_WB as workbook set Curr_WB = activeworkbook 'openworkbook 'do your thing Curr_WB.activate '---------------------------------------------------------- hth Carlo |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to open a workbook per active window | Excel Discussion (Misc queries) | |||
How to Active Window | Excel Programming | |||
keystroke to close active workbook window | Excel Worksheet Functions | |||
I can't adjust the window size of an active workbook. | Excel Discussion (Misc queries) | |||
active window | Excel Programming |