Re: OLE (XLS) question ABOUT: how to display a sheet

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Great someone is here to help me out.

I have:

Private Sub Command5_Click()

Workbook.Sheets(oneBasedIndex).Select
OLE1.object.Sheets(1).Select

End Sub

object not found (Workbook)

should this work under VB6?
where to place 'Workbook.Sheets(oneBasedIndex).Select' ?

Thank you.



""Walter Wang [MSFT]"" <wawang@xxxxxxxxxxxxxxxxxxxx> schreef in bericht news:erzUSoW3HHA.360@xxxxxxxxxxxxxxxxxxxxxxxxx
Hi "Online Help",

The OLE control has a property named "Object" which is the embedded ole
object, in this case, it's a Workbook in Excel object model.

To activate a Work*** in a Workbook, you can use following code:

Workbook.Sheets(oneBasedIndex).Select


Without referencing the Excel object library, you can use following code
safely (with late binding):

Private Sub Command1_Click()
OLE1.Object.Sheets(2).Select
End Sub


This will activate the second *** in the workbook.

Hope this helps.




Sincerely,
Walter Wang (wawang@xxxxxxxxxxxxxxxxxxxx, remove 'online.')
Microsoft Online Community Support

==================================================
For MSDN subscribers whose posts are left unanswered, please check this
document: http://blogs.msdn.com/msdnts/pages/postingAlias.aspx

Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications. If you are using Outlook Express/Windows Mail, please make sure
you clear the check box "Tools/Options/Read: Get 300 headers at a time" to
see your reply promptly.

Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
==================================================

This posting is provided "AS IS" with no warranties, and confers no rights.


.

Quantcast