VB opens Excel worksheets Hidden 1

[IFRs]

When I use VB6 to open an Excel worksheet, and then go to Excel, the worksheet is hidden and I have to unhide it to see it. Next time I use Excel to open the worksheet it is hidden.

How do I open it with VB6 UnHidden so the user can see my VB6 program manipulate it?


How do I make the worksheet open normally with Excel next time?

My code for opening it is Set XLObj=GetObject("Drive\Path\Filename.xls&quot

 

[joerd]

After the GetObject line, use
XLObj.Windows(1).Visible = True


Cheers,
Joerd

Please see FAQ731-376 for tips on how to make the best use of Eng-Tips.