I am trying to copy data from a query in my database to an excel sheet can anyone tell me why this is not working:
Set rst2 = CurrentDb.OpenRecordset("qryXXXX")
Do Until rst2.EOF
Set workSheet = appExcel.Worksheets("DataSheet" & i)
workSheet.Cells(rst2![CellRow]...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.