include module function??

toshesh · June 8th, 2006, 03:54 AM

Hi all,

I am trying to manage my modules and was wondering if VBA has the
ability to import/include/require modules at runtime from outside the project.At the moment I have duplicate modules for each ACCESS
vba and everytime I need to change something I have to change ALL of it.... Other programming language can do this so there must be a way
to do this in VBA...I hope

I have tried using the code below but this seems to just add
module everytime I open the form

Code:

Private Sub Form_Open(Cancel As Integer)
    'Application.VBE.ActiveVBProject.VBComponents.Import (Application.CurrentProject.Path & "\test.bas")

End Sub

Please could someone help me on this issue.

Thank you

mmcdonal · June 8th, 2006, 07:00 AM

Try deleting the existing module either before importing the new one, or import the new one, delete the old one, and rename the new one. Use

On Error Resume Next

(Import New Module)

If Err = 0 Then
(Delete Old Module)
(Rename New Module)
End If

Did that help?

mmcdonal

pjm · August 4th, 2006, 02:00 PM

I have the same issue myself. I've got quite a number of VBA functions/subs that I've written and I'd like to just include them with any new databases (instead of the constant copy & paste).

The way to do it (when I get the chance) is to put all the code in a .mda file and include a reference to it (Tools/References) in any new files.

-Phil-