Saving a new file with a macro

M

Mike

I have set up a query that retreives information from a MS Access dbase. I
then need to save that information as a tab delimited text file to be
imported into a diferent program. Is there a way, when recording a macro, to
have it pause for you to enter a file name, or better yet have it use one of
the tables cell information as the file name? Such as, cell A5 is a last
name. could the macro be recorded to saved that table as a text file with
the value of cell A5 being the name of the file?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top