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
|