var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: transferring query output into a spreadsheet
I am trying to export the result from a query into a spreadsheet. It works fine if I put the entire path to the spreadsheet into the code but it brings up errors if I am trying to following:
DoCmd.TransferSpreadsheet acExport, "(SE)qry_FindStatusChange", gstrAppDirectory() & "reports\StatusChange.xls", True
Anyone any ideas?
What exactly does gstrAppDirectory return? Likely it isn't correct.