Good Day,
I would like to express my interest in your project.
I am a BSc. (Hons) Computing degree graduate of the University of Greenwich (UK) and have over 10 years professional work experience in the IT industry. I am an expert in database design/development, SQL, MS Access, Visual Basic for Applications, data import and export to MS Excel, txt, and pdf, amongst others.
I would be very glad to provide you with an MS Access VBA-based solution which will:
(1) Use an MS Access table to maintain details of the Excel file to be incorporated into the MS Access report
(2) Dynamically select the worksheet indicated in the MS Access table
(3) Use the dynamic filename in your existing OLEUnbound function
Kindly clarify the following so as to facilitate more accurate scoping and solution design:
(a) A sample of the database that you are working on, including the report and current OLEUnbound function
(b) A sample of the Excel file
(c) Confirm which version of MS Access/Excel you are using
I look forward to providing you with a solution that meets and where possible, exceeds your requirements. (Excellent reviews and work samples are available on my profile page.) Please feel free to contact me in case of any queries.
With many thanks for considering my application.
Kind regards,
Jeane.