×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

VB opens Excel worksheets Hidden

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

RE: VB opens Excel worksheets Hidden

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.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources