Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2004
    Posts
    1

    Unanswered: filter by form to excel

    Does anyone know how to send filtered data(by using the fillter by form button) to excel using the preexisting "transfer spreadsheet" macro? I'd basically like to send this data to a particular sheet on an existing excel file located on the "C:\" drive.

  2. #2
    Join Date
    Oct 2003
    Location
    Canada
    Posts
    574
    use the transfer spreadsheet method/action to send a query that is using the same filter. The hard part is making the query.

Posting Permissions

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