Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to: Open closed workbook/Search data tables/Return data to open workbook | Excel Discussion (Misc queries) | |||
Opening Excel, Book1 opens, remains open with other workbook open | Excel Discussion (Misc queries) | |||
excel 2003 saved file will not open without a blank workbook open | Excel Discussion (Misc queries) | |||
Excel workbook does not open in open window on desktop | Excel Discussion (Misc queries) | |||
Open a password protected excel workbook from second workbook to fetch data using dynamic connection | Excel Programming |