IO am using this code to open and refresh an external excel spreadsheet from access, its not working?
Dim appExcel As Object
Dim excelwb As Excel.Workbook
Set appExcel = CreateObject("Excel.Application")
Set excelwb = appExcel.workbooks.Open ("c:\Log\dataset2.xlsx")
excelwb.refreshall
Set excelwb = Nothing
Set appExcel = Nothing
Dim appExcel As Object
Dim excelwb As Excel.Workbook
Set appExcel = CreateObject("Excel.Application")
Set excelwb = appExcel.workbooks.Open ("c:\Log\dataset2.xlsx")
excelwb.refreshall
Set excelwb = Nothing
Set appExcel = Nothing