Dear all,

I am looking for a solution for the following task:
I have a MOVEX ERP-System and I am querying data from various tables via ACCESS, e.g. financial bookings, spent hours, manufactured material, ... all combined under 1 project number. I now import my perfectly running queries into Excel, as most of our users are not familiar with Access, but Excel. So I've created a VB script accessing my queries and importing all data into pivot-tables. So far so good, everybody is happy.

But: In Access you can 'ask' for certain inputs like the project number, if you put the Criteria into cornered brackets, like this: [PROJECT]. Running the query now it would ask for the project number an retunr the matching results. It is working fine in Access, but I don't know how to use this function from Excel-side. Not knowing this I end up providing an Access-file for each project number, where the projetnumber is my fix criteria instead of having 1 central Access-query with a variable 'projectnumber' criteria for all my different projects.

Access_1.PNG

Does anyone know how to solve this?

Thank you very much in advance and have a nice day.

Best regards from sunny Sweden,
Ramon