Recent content by ctet143
-
C
Export multiple tables to one Excel worksheet
This is what I've been messing with and it keeps throwing error that it doesn't find my excel spreadsheet. For my first table: DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel12Xml, "qryNameFirst", "test1.xlsx", True, "MyWorksheetName" For my second table: Dim rstName As... -
C
Export multiple tables to one Excel worksheet
The_Doc_Man This will be a recurrent process performed by users that know nothing about Access other than pushing a button to perform an action. I originally found some code to find the end of the previous exported two lines (header line one with line two data record) then to add two lines and... -
C
Export multiple tables to one Excel worksheet
Pretty new to VBA. One table has header row (5 columns) and one detail record. Second table has header row (65 columns) and several detail records. Need to export row one to be header, row two detail line. Skip row three (should be left blank) row four should be header row, line five and on...