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.
-------------------

Show quoteHide quote

¤ 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)

Re: Help needed in using FSO's, TextStreams, etc. --- Code Review and Advice requested
listbox's SelectedIndexChanged keep fire
better way to program than this?
Array Question, Out of Bounds
how to save the textbox contents to sql server database
Newbie
Display Outlook Recipient Window from vb.net
sqlDataReader does not return correct sorted data
Errors when running from LAN server.
Form level focus monitor