Hi everybody,
I am a selfeducated VBA user and I have a lot of gaps in my knowledge. I
spent 3 weeks doing a small program, (the program should help my mates at
work), but as i suspected it does not run on the PC at work. (No problems on
my PC at all). I have Excell 2003, the one at work is 2000. I have used a
calendar control, which is not available on the PC at work. I canceled all
the parts of the code that have something to do with this calenadr control
but the program still doesnot run and what is worse after i canceled these
parts of the code, and tried to execute the program, excel crashes. Now to
make things even worse, the computer system at work is in a horable
condition. There is no system administrator or anybody with knowledge, to
take care for the system and it is very messy (no wonder since I am in the
hospitality industry). So i dont really know if the problem is with the
system at work, or with the VBA settings or if there is something to do with
the DLL or somewhere else. Can somebody please give me a clue where to look
for solution. If more information is needed I will provide it.
This is my first program done for a practical purpose and it will be at a
great help at work if only i can start it. If not the disappointment will be
great. I will greatly appreciate any help.

P.S. I have tried some other simple VBA excel codes at work (written in fact
on that PC at work and they are OK, but once i bring something from home
there is a problem)

I canceled all the parts of the code that have something to do with this
calenadr control ...
Did you also remove the reference to the DLL under the VBE Tools
References list ?


after i canceled these parts of the code, and tried to execute the program,
excel crashes.
No doubt your mates at work were all standing around watching at the time ;-)


Regards,
Vic Eldridge




"Apostol" wrote:

Hi everybody,
I am a selfeducated VBA user and I have a lot of gaps in my knowledge. I
spent 3 weeks doing a small program, (the program should help my mates at
work), but as i suspected it does not run on the PC at work. (No problems on
my PC at all). I have Excell 2003, the one at work is 2000. I have used a
calendar control, which is not available on the PC at work. I canceled all
the parts of the code that have something to do with this calenadr control
but the program still doesnot run and what is worse after i canceled these
parts of the code, and tried to execute the program, excel crashes. Now to
make things even worse, the computer system at work is in a horable
condition. There is no system administrator or anybody with knowledge, to
take care for the system and it is very messy (no wonder since I am in the
hospitality industry). So i dont really know if the problem is with the
system at work, or with the VBA settings or if there is something to do with
the DLL or somewhere else. Can somebody please give me a clue where to look
for solution. If more information is needed I will provide it.
This is my first program done for a practical purpose and it will be at a
great help at work if only i can start it. If not the disappointment will be
great. I will greatly appreciate any help.

P.S. I have tried some other simple VBA excel codes at work (written in fact
on that PC at work and they are OK, but once i bring something from home
there is a problem)