Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations TugboatEng on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

VB opens Excel worksheets Hidden 1

Status
Not open for further replies.
IFRs

IFRs

Petroleum
Joined
Nov 22, 2002
Messages
4,680
Location
US
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")
 
Sort by date Sort by votes
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.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

JoelTXCive
  • Locked
  • Question Question
Excel VBA - Printing Code in Color?
Replies
0
Views
1K
JoelTXCive
JoelTXCive
JoelTXCive
  • Locked
  • Question Question
Excel Named Ranges and VBA
Replies
3
Views
1K
IDS
IDS
JoelTXCive
  • Locked
  • Question Question
Sending an Array into an Excel VBA function and Also Getting an Array Out
Replies
6
Views
1K
IDS
IDS
SBaugh
  • Locked
  • Question Question
VBA Automation tools
Replies
3
Views
1K
SkipVought
SkipVought
JoelTXCive
  • Locked
  • Question Question
Excel VBA Global Range Object
Replies
15
Views
2K
JoelTXCive
JoelTXCive

Part and Inventory Search

Sponsor

Back
Top