Reference Errors with Distribution of excel sheets with macros
 

I developed an excel mailing cost simulator using standard excel 2003 macro
support. Some of the users are getting the "can't find project or library"
message when the auto open macro starts. It appears that the calendar module
is missing from the reference table at the very least. I added a trap to the
code to avoid the debug screen for those users but they cannot use the system
until I get a solution.

Questions;
1. How can I reliably distrubute excel work without worry about individual
stations.
2. What do I do to correct the missing calendar module at the stations
complaining.

Reference Errors with Distribution of excel sheets with macros
 

You might be able to use late binding to solve some of your problems.

http://peltiertech.com/Excel/EarlyLateBinding.html

As far as the calendar control is concerned, I think they'll have to have it
loaded on their system.
--
HTH,

Barb Reinhardt



"Marvin" wrote:

I developed an excel mailing cost simulator using standard excel 2003 macro
support. Some of the users are getting the "can't find project or library"
message when the auto open macro starts. It appears that the calendar module
is missing from the reference table at the very least. I added a trap to the
code to avoid the debug screen for those users but they cannot use the system
until I get a solution.

Questions;
1. How can I reliably distrubute excel work without worry about individual
stations.
2. What do I do to correct the missing calendar module at the stations
complaining.