Unanswered: I know it might be a dumb question, but it has me going crazy!!!
In excel there is thisworkbook object to refer to the open workbook. How I do that in access? How's the object called? I have all the code done but still trying to figure it out. Looked thru the forums but no luck. Thanx
Go to tools, reference and select Microsoft Excel xx Object Library
- - - - -
WorksheetName = "c:\myExcel.xls"
Set objExcel = CreateObject("Excel.Application")
Set objExcelWorksheet = objExcel.ActiveWorkbook.Sheets(WorksheetName)
objExcelWorksheet.Cells(1, 1) Will then refer to Row1, Cell1