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.
|