Microsoft Visual Basic For Applications Extensibility Library

I am using Office 2000 on Windows 2000 SP4.

I have an associate who receives a spreadsheet with employee data from Human Resources. Unfortunately there is no rhyme nor reason behind how the incoming spreadsheet is named.

I have the VBA that will do the manipulations the associate needs, and have saved the module as "randMod.bas".

If I could rely on a reliable file name, she could put this into her personal.xls file and all would be good in the country.

What I would like to do is create a routine in her personal.xls file and give her a button to activate that routine.

I would like the button to import "randMod.bas" into the active workbook with the employee data. My theory is that if the module is in the actual employee file, I don't need the file name to do the manipulations required.

I have tested this by manually importing the module and running the routines and all is good.

Now, I need to know how to give her the ability to click a button that will import the module.

In http://www.excelforum.com/showthread...00890#poststop there is a routine that I cannot make work. It does not get past the line: Dim myVBP As VBProject

Jason says to "Make sure you add the Microsoft Visual Basic For Applications Extensibility Library before running, but I don't know how to do that.

Under Tools > References, the following are checked: Visual Basic for Applications, Microsoft Excel 9.0 Object Library, OLE Automation, & Microsoft Office 9.0 Object Library.

In the Vb editor go to tools >references and put a tick in the box beside
Microsoft Visual Basic For Applications Extensibility see pic

I must have looked through that list three times and could not find "Microsoft Visual Basic For Applications Extensibility Library" Seeing your pic, I scrolled down about the same distance on the scroll bar and there it was!!