Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Open Excel
- Thread starter Dickx
- Start date
tonyflavell
Programmer
Try
Dim MyXL as Excel.Application
Dim MyWorkbook as Excel.Workbook
Dim MySheet as Excel.WorkSheet
Set MyXL = New Excel.Application
Set MyWorkbook = Excel.Workbooks.Open("C:\Order.xls")
Set MySheet = MyXL.Sheets("Sheet 1")
You may have to play with this depending on the version of Excel and Access. Also look in "HELP" for the "GetObject" function.
Tony
Dim MyXL as Excel.Application
Dim MyWorkbook as Excel.Workbook
Dim MySheet as Excel.WorkSheet
Set MyXL = New Excel.Application
Set MyWorkbook = Excel.Workbooks.Open("C:\Order.xls")
Set MySheet = MyXL.Sheets("Sheet 1")
You may have to play with this depending on the version of Excel and Access. Also look in "HELP" for the "GetObject" function.
Tony
- Status
Similar threads
- Question
- Locked
- Question
- Locked
- Question
