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
|