Search Window in Form while importing

  • Thread starter Thread starter Kellie
  • Start date Start date
K

Kellie

While in a Form, I am importing Excel worksheets. I know
how to do the coding if I enter the file name and path.
However, I would like to have browser window pop up where
I can choose my file name and path on the fly.

Currently I have:

DoCmd.TransferSpreadsheet acImport,
acSpreadsheetTypeExcel8, "NewTableName", "FilePathAndName",
True

This must be possible....but I can't figure it out.

Any help would be greatly appreciated.
Thank You
 
Back
Top