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. |
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 |
All times are GMT +1. The time now is 09:30 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com