dimanche 1 mars 2015

Addittional parameters using macro from Excell to pull data from Access

I have a query in access database. And I need to record macro to pull data with this query from Access. But, when I pull that query with macro and Excel automaticly create a Sub with macro code. Problem is in that I need edit data in where clause of query in that macros Sub to add parameter from Excel (user input this data on one sheet). How can I write this ? Help me please, because I dont have an idea anymore.


Aucun commentaire:

Enregistrer un commentaire