export table to location of choice

[Vicky]

I have created a Macro which exports the table to a specific location.
How can I get a promt to choose the location where I would like to export
the data to. Any one knows how to do this?

 

[Klatuu]

Here is a site with code that allows just what you want. Your macro,
however, will have to change or disappear. It will require some VBA to
accomplish what you want.

http://www.mvps.org/access/api/api0001.htm

 

[vicky]

Hi Klatuu!
thank you so much, wil try it out.

Here is a site with code that allows just what you want. Your macro,
however, will have to change or disappear. It will require some VBA to
accomplish what you want.

http://www.mvps.org/access/api/api0001.htm