| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
To open workbooks: how to put behind wbk in front?
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
To open workbooks: how to put behind wbk in front?
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
To open workbooks: how to put behind wbk in front?
Fred, it is always better to refer the workbook when you open..
Dim wbBook1 As Workbook Dim wbBook2 As Workbook Set wbBook1 = Workbooks.Open("<fullpath\<filename.ext") Set wbBook2 = Workbooks.Open("<fullpath\<filename.ext") wbBook1.Activate If this post helps click Yes --------------- Jacob Skaria "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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
To open workbooks: how to put behind wbk in front?
I do this:
Dim wbFirstName as string ' do stuff that opens the first workbook wbFirstName = Activeworkbook.name ' your code here that opens second workbook Workbooks(wbFirstName).activate "Jacob Skaria" wrote: Fred, it is always better to refer the workbook when you open.. Dim wbBook1 As Workbook Dim wbBook2 As Workbook Set wbBook1 = Workbooks.Open("<fullpath\<filename.ext") Set wbBook2 = Workbooks.Open("<fullpath\<filename.ext") wbBook1.Activate If this post helps click Yes --------------- Jacob Skaria "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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| To open workbooks: how to put behind wbk in front? | Excel Programming | |||
| To open workbooks: how to put behind wbk in front? | 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 | |||
Linear Mode
