Link to home
Start Free TrialLog in
Avatar of Fed Alexander
Fed Alexander

asked on

Prompt to open file

Hello Experts,

please find attached. i have a button in the dashboard that when clicked, i want it to prompt me to open a excel. currently, it opened to the following location

 strExcelPath = "C:\Users\Alexander\Desktop\MONTHLY.xlsx"

the location sometime change. i want to be able to search when the dialog box open. note the excel file is the same format as the access table.

your help please!
e-Database---Copy.accdb
SOLUTION
Avatar of therealmongoose
therealmongoose
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Fed Alexander
Fed Alexander

ASKER

Thank you, can you implement this in the database sample i sent? i tried but encountered issues
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Thank you amazing team!