Output to TXT File

[BradCustom]

I'm using Access 2007 and I've created a Macro that outputs a table to a text file. Everything works fine but the export requires user input. I was wondering if there is a way to export without the user having to answer the Export Wizard questions.

The questions that need to be answered are:
Path:       OK
Overwrite:  Yes/No
Format:     Fixed Width

Finish
Close

Perhaps this would be better handled with VBA?

Thanks for your help!

 

[PHV]

In VBA, use the DoCmd.TransferText method.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[BradCustom]

How can I add the DoCmd.TransferText to an exsisting Macro?

Thanks for your help!