Exporting OpenForm results to a spreadsheet?

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: system404 (anonymous_at_discussions.microsoft.com)
Date: 03/09/04

  • Next message: Chris Grant: "Error Message When linking to macros" 
    Date: Tue, 9 Mar 2004 13:33:04 -0800

    I have created a data entry interface for a database I've
    been working on and am trying to create a macro that will
    compile only the data just keyed to export into an excel
    spread*** for use in tracking productivity. I tried a
    TransferSpread*** macro, but could only determine how
    to link it back to the main table - resulting in
    exporting the entire database table rather than just the
    query results I am looking for.

    Currently I've figured out how to pull the recently keyed
    data into a data*** using an OpenForm command directed
    to a form populated by my query results; now I have to
    determine if it is possible to automatically export this
    data*** as an .xls file to the All Users\Desktop
    directory.

    Is there a way I can combine these two commands to get
    the results I'm looking for? Or does anyone have any
    other altenatives they could offer?

    Thanks for your time.
    -404

  • Next message: Chris Grant: "Error Message When linking to macros"
    • Quantcast