How to call a procedure stored in a remote mdb? 1

[steve728]

Will someone please provide me with some VBA code that enables me to call a Public Sub Proc that is stored in a remote (same drive and folder) MDB file.

Thanks,

Steve728

 

[Remou]

You can add an mdb or mde as a reference. Here are some notes:

Sub Ref_Remove()

Application.References.Remove Application.References("Tek-Tips")

End Sub

Sub Ref_Add()

Application.References.AddFromFile "C:\Docs\Tek-Tips.mdb"

End Sub

Sub Run_Sub()
'Note that this will not compile
Call CloseAll

End Sub