Re: Exporting OpenForm results to a spread***?

From: Steve Schapel (schapel_at_mvps.org.ns)
Date: 03/10/04 

Date: Wed, 10 Mar 2004 18:18:44 +1300

404,

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

-- 
Steve Schapel, Microsoft Access MVP
system404 wrote:
> 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