Windows dialog box

[polina]

Hi,

In order for me to import the excel file, I have to take the exact path from the user (which I do using a text box)

txtPath.SetFocus
path = txtPath.Text
DoCmd.TransferSpreadsheet acImport, , "1", path, True


But that is of course a headache for the user to type the whole path into the text box.

How could I open a windows dialog box so the user would browse for the file?

Please help.

Thanks

 

[DES]

samples

http://www3.sympatico.ca/qaissuper/