This link has the code to allow the user to select the folder and file name:
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - [url]http://allenbrowne.com/tips.html[/url]
Reply to the newsgroup. (Email address has spurious "_SpamTrap")
"Frank Dulk" <fdulkbol.com.br> wrote in message
> I need to create a form of exporting a table for a format txt. I know that
> can create a macro for that and tie I already did. Only that to macro
> already defines the name of the file destiny, while I need that the usershe> the option of typing the name of the file that will be generated by that
> export, Jan2003.txt, Balancete.txt, for instance. Do I imagine then thatmodulate> can make that road some I modulate, once I found modules that copy or do
> they move files, why some not to exist to name? Like this, it could export
> the table with the fixed name for the same macro and to use that I> to name for the name that the user wanted.
> I know that that and a super task, but I believe that is not something
> I thank the attention