View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
RSunday RSunday is offline
external usenet poster
 
Posts: 19
Default 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?