Re: Export like a Save As

From: Dirk Goldgar (dg_at_NOdataSPAMgnostics.com)
Date: 03/23/04 

Date: Tue, 23 Mar 2004 15:48:43 -0500

"Marc" <anonymous@discussions.microsoft.com> wrote in message
news:d8d501c4110f$f32ada30$a001280a@phx.gbl
> I would like to use the "DoCmd.TransferSpread***
> acExport" for exporting a Query but emulating a Save As.
> This is: when clinking on the export button, a form will
> pop up allowing the user to navigate into his or her own
> hard drive to identify the destination of the excel file
> and then enter its name. Especially I am interested that
> the PopUp form allows the user to navigate into his or her
> hard drive without having to type manually the file path.

You can adapt the code at:

    www.mvps.org/access/api/api0001.htm

to display the Windows File Save dialog. 

-- 
Dirk Goldgar, MS Access MVP
www.datagnostics.com
(please reply to the newsgroup)