WO2015
asked on
ACCESS - Export Multiple Blank Header Lines
Hello,
I have a query that has been working correct for years. The client has 1 request, they want 3 BLANK header lines above the regular header and data. What I have set up is:
A macro that runs three queries and a RunCode() Module. That Module runs and exports the final query and names the file. How can I add these 3 blank header lines? Thank you!
I have a query that has been working correct for years. The client has 1 request, they want 3 BLANK header lines above the regular header and data. What I have set up is:
A macro that runs three queries and a RunCode() Module. That Module runs and exports the final query and names the file. How can I add these 3 blank header lines? Thank you!
Is it text file? Can you show piece of code with export?
ASKER
Here is the module, the other items are just queries populating tables for this query to put all together for the output.
Function Discover()
DoCmd.OutputTo acOutputQuery, "CallReport", acFormatXLSX, "N:\CALLS_" & Format(Date, "mmddyy") & ".xlsx"
End Function
Function Discover()
DoCmd.OutputTo acOutputQuery, "CallReport", acFormatXLSX, "N:\CALLS_" & Format(Date, "mmddyy") & ".xlsx"
End Function
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you, that worked perfectly!!