Wrong Settings Or Something Else

A

Apostol

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)
 
V

Vic Eldridge

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top