Select File name for import or export of spreadsheet

[RBPM]

Good afternoon - Was hoping to enlist some help from the community - Have an access application where excel spreadsheets are both imported and exported. Am currently using macros to perform the imports and exports.

Within the macro using the transfer spreadsheet action have currently hard coded the full file path in the file name field.

Objective is to be able to browse for the file path and name. Is this doable?

Any help would be greatly appreciated. Thanks

 

[Remou]

Hi
Have you seen "IMPORT Excel Sheet into Access allowing user to select file", thread705-760625
You may find it useful.