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.
You can add an mdb or mde as a reference. Here are some notes:
Code:
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
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.