Referencing VBA code book in Access (1 Viewer)

[DonkeyKong]

I use Excel a lot, and in Excel I have created small code libraries that contain functions that I use over and over and over and over.... The one I am concerned with has functions that are responsible for executing commands within a seperate application. I have saved this as an xla file or an excel add in.

I would like to reference this code library in Access, but Access doesn't accept .xla files (obviously) and it doesn't have it's own version of an add in file extension. Is there anyway I can reference this here? It is a crucial part and I have no need for Excel in this project.

More specifically is there a way for me to have a Excel/Access cross platform compatable code book so that I could reference it in both applications and have only one version that I need to maintain? This would be ideal!

Thanks in advance!

 

[DonkeyKong]

I stand corrected: mda is the Access add on file extension.

http://www.databasedev.co.uk/access-add-ins.html