Trying to call access functions in excel

[DKY]

I have an access database on one of our network drives that has some visual basic programming in it. In this programming is a function that looks at data and manipulates it a certain way and I would like to be able to call into my excel files.

The creator of this program constantly uses it in access and is always updating the program. If I were to just simply copy and paste every once in a while I would miss any edits that he makes to the program. Another reason that I want to link to it is because many of us use this program and it would be great if we can just draw from one source. Any ideas? Is this possible?

[Leith Ross]

Hello DKY,

Just because a function in Access is written VB or VBA doesn't guarantee it will work in Excel. Access is a relational database program. Excel is a spreadsheet program. Data is manipulated according to the application's design, and not by VB or VBA. You would need to post the macro code to get a definitive answer on this question.

Sincerely,
Leith Ross

[DKY]

I don't know, how's this?

Please Login or Register  to view this content.

I'm just curious if it's possible and if so, how? I see that you can do it the other way around:
http://support.microsoft.com/kb/153748

[DKY]

Here's what I've got so far in Excel:

Please Login or Register  to view this content.

So somewhere in there I have to refer to the Access database and the function inside of it but how?????

[DKY]

K, so here's where I'm at so far

Please Login or Register  to view this content.

This will run 'macro1' in database.mdb but I can't figure out how to run a function instead. HELP?!?! I'm almost there.....