OLE Question

[nakedpanic]

Is there a way for me to open a selected Excel worksheet from a workbook using OLE.CreateLink. I know I can use a file name but how can I specify which sheet to display? Or is there maybe a better way for me to simply display an Excel worksheet in a VB Form. I just want to display with no active editing functionality. However, I do want the ability to print the Excel worksheet.

Thanks for your help,
Karl

 

[daimaou]

You can add something like this to your code:

OLE1.object.worksheets(3).Select

This would show worksheet number 3 on your OLE object(OLE1). I think you cannot set wich worksheet to open on the OLE object properties. But this should do the trick.

Hope this helps