PDA

View Full Version : [SOLVED:] Compile error message


maralica
07-06-2005, 10:28 PM
Hello!

Error message appears Excel program when I attempt to start macro with command button in form of my program. Error appears only on one computer on network (I suppose that problem is in version of Excel on that computer).

Error message is
Compile error
Can't find project or library.

VBA Code is OK. Because thing works on other computers

Thanks in advance:help
Marin
sheeeng
07-06-2005, 10:34 PM
Welcome to VBA Express...:clap:

Can we have a look at the file?
maralica
07-06-2005, 10:59 PM
Code or complete file?
maralica
07-06-2005, 11:01 PM
Welcome to VBA Express...:clap:

Can we have a look at the file?

VBA Code or complete file?
Justinlabenne
07-06-2005, 11:54 PM
If you have different versions of Excel that the file is shared on, it is quite possible that a reference set for use by the code is causing your trouble. Set references are not backwards compatible, so they can be quite annoying if you use different versions of Excel.

If you can, attach the file in zip format, and specifiy what versions on Excel this file may encounter, or check in the VBE under Tools > References and see what has a checkmark next to it.

Best bet is to attach the file.:yes
Bob Phillips
07-07-2005, 12:12 AM
Error message appears Excel program when I attempt to start macro with command button in form of my program. Error appears only on one computer on network (I suppose that problem is in version of Excel on that computer).

Error message is
Compile error
Can't find project or library.

VBA Code is OK. Because thing works on other computers


This is usually caused by a missing library.

Go into the VB IDED, and in Tools>References, see if any items are marked as missing. Uncheck them if so0, and try again.
maralica
07-07-2005, 01:36 AM
I saw marked this ...
Missing Windows Common Controls-26.0(SP4)
Bob Phillips
07-07-2005, 02:31 AM
I saw marked this ...
Missing Windows Common Controls-26.0(SP4)

So did you uncheck it and it solved the problem?
maralica
07-07-2005, 02:35 AM
I can't find file mscomct.ocx
Bob Phillips
07-07-2005, 02:43 AM
I can't find file mscomct.ocx

Do you need it?
maralica
07-07-2005, 02:49 AM
I copied that file from my computer to that shared and it works now,

Thanks
sheeeng
07-07-2005, 07:04 AM
VBA Code or complete file?

Which is better for you?
You hav better internet connection, put the complete file...
You hav slow internet connection, put the code...

ps. Sorry for late reply..:(