Help with Folder Dialogue box 1

[unclesvenno]

From Access97 I am providing functionality to allow the user to export a query result to an Excel97 spreadsheet. Got it working well but I would like to give the user the option to select where to save to. I was thinking something along the lines of a Folder Dialogue box or a Save As Dialogue box. Any suggestions on how to do this?

I have come from programming in Java and loving the online API documentation. Does anything like this exist for VBA? If so where can I find it?

Thanks again
Uncle Svenno

 

[RoyVidar]

Here's some links to file/folder browsing Call the standard Windows File Open/Save dialog box, BrowseFolder Dialog.

For API documentation, are you looking for something like this
Allapi Network?

Roy-Vidar

 

[unclesvenno]

Great, thanks a lot RoyVidar, did the job. I found all three links to be quite usefull.

Uncle Svenno