Automating Excel - Is Visible the Default?

  • Thread starter Thread starter Elliot
  • Start date Start date
E

Elliot

After executing the following line:

WB = XL.Workbooks.Open("c:\test.xls")

Excel is visible using vb.net 2005. Is this a change from previous
versions of VB? I know I can use xl.visible=false after this line but
it is a nuisance to have excel pop up even for a second when I don't
use its interface.

Thank you,

Elliot Semmelman
 
Why not set it to visible before opening the workbook?
Aren't you opening Excel before this? Can't you set
[Visible] = false after that and before this?

Robin S.
 
¤ After executing the following line:
¤
¤ WB = XL.Workbooks.Open("c:\test.xls")
¤
¤ Excel is visible using vb.net 2005. Is this a change from previous
¤ versions of VB? I know I can use xl.visible=false after this line but
¤ it is a nuisance to have excel pop up even for a second when I don't
¤ use its interface.

The default behavior is that Excel is not visible.

Could there be some auto macro code in the Workbook that is causing the UI to become visible?


Paul
~~~~
Microsoft MVP (Visual Basic)
 
Back
Top