Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Questions for VB6
How can you connect to an Excel spread sheet via VB6 (not VBA) to retrieve
information from specfic cells? Thanks, Aaron |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Questions for VB6
Aaron,
Big question. Essentially, it is the same as you would do from VBA. Create an in stance of Excel, and then navigate through the Excel object model Dim xlApp As Object Dim xlWorkbook As Object Dim xlSheet As Object Set xlApp = CreateObject("Excel.Application") xlApp.Visible = True Set xlWorkbook = xlApp.Workbooks.Open("C:\myTest\myFile.xls") Set xlSheet = xlWorkbook.Worksheets(1) MsgBox xlSheet.Range("A1") xlApp.Quit Set xlApp = Nothing -- HTH Bob Phillips "Aaron" <NONE wrote in message ... How can you connect to an Excel spread sheet via VB6 (not VBA) to retrieve information from specfic cells? Thanks, Aaron |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Answers to questions posing more questions in a workbook | Excel Worksheet Functions | |||
View Questions and Answer to questions I created | Excel Discussion (Misc queries) | |||
Excel '07 Questions | Excel Discussion (Misc queries) | |||
have several excel questions | Excel Worksheet Functions | |||
several excel questions | Excel Discussion (Misc queries) |