Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Prompt Access for Any Excel File

Status
Not open for further replies.

DIVINEDAR0956

IS-IT--Management
Aug 15, 2002
95
0
0
US
I have this program that links excel with access and what I want to do is have access prompt for a certain directory where files are stored for future use. These files would have to be linked to access each time. I can do the macro to delete the link but my problem would be, have whatever file that is choosen to automatically link to access. So what I'm looking for is a wildcard to ask for what ever to pull into access.

Anyone any ideas.

Thank you.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top