Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2003
    Location
    UK
    Posts
    1

    Unhappy Unanswered: Outputto filename selected from a query

    I am having problems exporting data from Access to Excel within a Macro.

    Using the Outputto command I can output to a selected filename, which works fine.
    What I would like to do is export to a Filename selected from a table.

    I have searched the WEB for days without success, so far my outputfile syntax looks like this..

    "M:\finance\"&[Query_filename]![filenam]&".xls"

    P.S I haven't used VB (yet!)

    Thanks in advance
    JFH

  2. #2
    Join Date
    Aug 2003
    Location
    Bosnia & Hercegovina
    Posts
    57
    you will have to use VBA to do this, look up in help DoCmd.TransferSpreadsheet....

    or even better, first convert your macro to VBA and check it out....

    then you will need some knowledge about recordset and.......

    try the first part, and then see what next....

    good luck....

Posting Permissions

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