Recent content by a497253

I had to enable the Microsoft Activex data objects 2.1 library but after that it worked like a charm. Thanks!

I am using MS Access 2003/2007. I understand that there is an Output To macro that will export selected queries into an Excel (xls, xlsx) format to a specific path that can be converted to vba: DoCmd.OutputTo acOutputQuery, "QueryName", "ExcelWorkbook(*.xlsx)"...