Attach reference/ library to file sent to users

[Guest]

When i sent a vba programmed file to users, some of them don't work because
of missing references.

Is it possible to attach reference to file sent so that everyone can run the
program?

 

[NickHK]

If the reference is "Missing", then the user does not have that component on
their system. How can you use it ?
Either only use components that are known to be present, or use some form of
Installation routine.

NickHK

 

[Guest]

What is installation routine?

i put a calendar control object in my excel file, the user didn't have this,
so i download from internet, but when I install there is a message that there
is no MS Form library in her machine and the calender object cannot be
installed.

Even more seriously, I have to send this file to 20 more users.

 

[Guest]

I have some VBA codes written for Excel and some other code for MS Project. I
have to let other people who also have the same office installation to use
the office files containing these codes. The required dll files are present
on the users machine.

Can some one please tell me how I can make a VB6 excecutable file that will
set the references required by my VBA codes.