View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Kevin R[_2_] Kevin R[_2_] is offline
external usenet poster
 
Posts: 4
Default Open excel and workbook with VB6

How can I open a given spreadsheet on a specific worksheet using vb6 code?

Thanks!

Kevin
================
I'm doing this:
Dim oBook As Object
Dim oSheet As Object

If FindWindow("XLMAIN", vbNullString) Then
Set gbl_oExcel = GetObject(, "Excel.Application")
Else
Set gbl_oExcel = CreateObject("Excel.Application")
End If

Set oBook = GetObject(Me.txtSelectedSpreadsheet) '(this is my selected
spreadsheet)
Set oSheet = oBook.Worksheets("Parameters")

What syntax after this will make the spreadsheet and "Parameters" worksheet
visible?