export query question

[QuietRiot]

didn't know whether this would be a macro or module or what

right now I have a query that I right click on and go to export then I change it to Text. I then set it to Fixed Width and then under advanced i set field information i changed the width from 255 to 181 but keep start 1 and field name "Expr1".

i would like a macro or code that would automate this whole process for me.

thanks,
QR

 

[FoFa]

Save your export format as an export specification.
If the filename is constant, you can use a Macro, otherwise you should use DoCMD.TransferText command in VBA (see help). You can feed that a filename either from an input or form, use your export specification in either command.

 

[QuietRiot]

I got it thanks!!!