Allowing user to select Excel Spreadsheet to link to

[jercsr]

I have several Excel spreadsheets that are stored in seperate project directories.

Is there a way to prompt a user in a dialog box or switchboard, or when they run the report to select or type in the Project number that they want to base their data from, capture their entry, and have Access automatically link to the spreadsheet in that directory? To make it easier, the spreadsheet name will be the same as the project directory name, so that the "variable" can be used to locate the correct Excel file. The linked table name will always be the same name in the "Front End".

Any ideas ?

Thanks

 

[JeremyNYC]

Jeremy,

You'll have to get into dealing with the common object dialog. I don't have any code for it at hand, but that's one of the six gadzillion useful bits of code in the Access [version number] Developer's Handbook, which you should run out and buy if you don't already have it. THe amount of time and money this book will save you is simply amazing. It's the best thing out there.

I'm sure you'll find tons of code by searching for it here or on comp.databases.ms-access archives at groups.google.com.

Jeremy

==
Jeremy Wallace
AlphaBet City Dataworks

http://www.ABCDataworks.com

Access Databases for Non-Profit Organizations

Please post in the appropriate forum with a descriptive subject; code and SQL, if referenced; and expected results. See thread181-473997 for more pointers.

 

[jercsr]

Thanks, Jeremy.

I appreciate the help.

Jeremy