dimanche 19 avril 2015

Using MS Access to run code in excel vba

I pull a query off SQL Server using an access front-end. I then export the recordset to a new Excel workbook. I want to then use excel to run code that I have in Access. It simply loops through cells and adds formatting and checks for a certain value. I can run it from access which will it has the workbook opens loops through fine. However it is painfully slow.

If I go into excel and paste the code that access is running for the formatting and check. It runs within seconds. But running it from access takes over 10 minutes.

Anyone got any ideas if this can be done?

Aucun commentaire:

Enregistrer un commentaire