Exporting Text SDF

[kevcri]

I create a lot of standard fixed length files for use on an as/400. I'm trying to create an application which will do the bulk of the work.

What I would like to do is set up a macro to export a table from the mdb, however I would like it to prompt the user for location and filename. is this posible?

Thanks all
Kevcri