TransferText and SaveFileDialog

[Guest]

I have a form that allows users to transfer different text files from tables
based on input from the form using docmd.transfertext.... I need to allow
the user to specify the export location and filename using a savefiledialog
type of interface. I think I can do this using .net but I am not ready to
move this database to .net at this time. I have tried using select file and
save file dialog types to get the path and filename but have not solved the
problem yet. (I would like to pass the pathname from the savefiledialog to
the path paramater of the transfertext function). I don't know what to try
next. Does anyone have a suggestion to solve this problem? Thanks for your
help.

 

[Graham Mandeno]

Hi Andy

You can use the Windows built-in open/save dialog box by directly calling
the API in comdlg32.dll.

There is some very good example code here that you can simply cut and paste:
http://www.mvps.org/access/api/api0001.htm