Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2009
    Posts
    37

    Unanswered: transferring query output into a spreadsheet

    Hi

    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?

  2. #2
    Join Date
    May 2005
    Location
    Nevada, USA
    Posts
    2,888
    Provided Answers: 6
    What exactly does gstrAppDirectory return? Likely it isn't correct.
    Paul

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •