| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Opening Excel via Access
This is a "shot in the dark" since I can't replicate the
environment you described, but you could try this alternative code. Set xlApp = CreateObject("Excel.Application") With xlApp.Application .Workbooks.Open("C:\Test.XLS") .Visible = False End With Set xlSheet = xlApp.Workbooks("Test.XLS").Sheets("Sheet1") Good luck, Merjet |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Opening an Excel workbook with VBA from Access | Excel Worksheet Functions | |||
| Opening an ACCESS db from the VBE in EXCEL | Excel Discussion (Misc queries) | |||
| Opening an ACCESS db from the VBE in EXCEL | Excel Worksheet Functions | |||
| Opening an ACCESS db from the VBE in EXCEL | Excel Worksheet Functions | |||
| Opening Access From Excel | Excel Discussion (Misc queries) | |||
Threaded Mode
