Use Access VBA functions from Excel
I have a database in Access with some programmed calculation routines in VBA.
Now I would like to use these routines in Excel - but I dont want to write
them again.
I thought I would just reference the .mdb file from Excel VBA
(tools-references- browse for .mdb files) - but I just get the message that I
cant add a reference to the specified file.
Is there a way to use routines from .mdb in Excel-VBA?
|