UDF to return value from Access Database

[sike64]

Hey,

I created a UDF in VBA that calls a value from an Access Database. It works, but it is absurdly SLOW. It takes like 20 secs to get 1 cell of data, and if you try to call >5 cells it will lock up excel. Does anyone have any ideas on how to make this faster and thus actually usable? Code below:

Please Login or Register  to view this content.

Thanks!


Moderator Edit:

Welcome to the forum, sike64.

Please notice that [CODE] tags have been added to your post. The forum rules require them so please keep that in mind and add them yourself whenever showing code in any of your future posts. To see instructions for applying them, click on the Forum Rules button at the top of the page and read Rule #3.
Thanks.