Exporting OpenForm results to a spreadsheet?

[system404]

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
spreadsheet for use in tracking productivity. I tried a
TransferSpreadsheet 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 datasheet 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
datasheet 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

 

[Steve Schapel]

404,

Just enter the name of the query into the Table Name argument of the
TransferSpreadsheet macro.

 

[system404]

That did the trick! Your help is greatly appreciated.

-404