VB opens Excel worksheets Hidden
VB opens Excel worksheets Hidden
(OP)
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")
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")
RE: VB opens Excel worksheets Hidden
XLObj.Windows(1).Visible = True
Cheers,
Joerd
Please see FAQ731-376 for tips on how to make the best use of Eng-Tips.