save query as csv file to changing location

[cgclower]

Hello!

I have written an Access macro that will take a query I have and save it as a .csv file. The problem is that (using the TransferText command) I have to specify the file name and location to save it in advance, as part of the TrasnferText command.

Is there a way to do this so that the Save As window opens, or something like that so that the user can specify where and what name to save the .csv file as?

Thanks!

Chris

 

[Joe4]

I have used this code before to bring up a file dialog box to select the file location and name of the file I want to save: http://access.mvps.org/access/api/api0001.htm

 

[SydneyGeek]

FWIW, here is an updated approach to the code that Joe posted.
It seems a bit more compact, and could be worth a look...
http://msdn.microsoft.com/en-us/library/aa140112(v=office.10).aspx

Denis