Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
To open workbooks: how to put behind wbk in front?
So you want to just activate the workbook (or window) that was active before
your code started? Dim ActWkbk as workbook set actwkbk = nothing on error resume next set actwkbk = activeworkbook on error goto 0 'your code here if actwkbk is nothing then 'nothing was active when you started else actwkbk.activate end if fred wrote: That can be the problem. If the workbook is already opened before my app starts I will not know its name. Thanks, Fred "Dave Peterson" wrote in message ... If you know the name of the workbook being opened: Workbooks("book999.xls").activate fred wrote: Hello, My app opens 2 workbooks using Excel automation. The second wrkbook is displayed in front. How to put the first wrkbook in front? Thanks, Fred -- Dave Peterson -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel2007; workbooks.count is not counting all open workbooks | Excel Programming | |||
use hyperlink to open file as front screen | Excel Discussion (Misc queries) | |||
how do I open a publisher file in front page | Excel Worksheet Functions | |||
Excel 2003 Workbooks.Open with CorruptLoad=xlRepairFile fails on Excel 5.0/95 file due to Chart, with Error 1004 Method 'Open' of object 'Workbooks' failed | Excel Programming | |||
Open a file with Front Page from Excel | Excel Programming |