My programme only runs how it should on my computer

Hello all,

I have a few problems with regards to my programme being run on different computers. I developed my code on Excel 2010 and the problems are being faced on Excel 2010 as well as other versions. The main issues I currently face are:

1)I have a code that outputs a result and formats it to 4 decimal places. This works fine on my computer but not others, the code is:

Please Login or Register  to view this content.

Is there another way to do this?

Error Message:
“Compile error:
Can’t find project or library”
If I remove the format it works fine.

2)I have included Month View calendars. I assumed all excel programs come with this, but this does not seem to be the case. Am I correct to say this or is there a wider issue?

Error Message:
“Could not load some objects because they are not available on this machine. “
Any help is appreciated.

Thanks in advance.

Hi Imprial,
1) This usually happens with the Format and Len functions, when there is a missing link. Look in the VBE Tools - References and uncheck if there is a "Missing".
2) "I assumed all excel programs come with this" - no

Hello nilem,

1) Done the trick.
2)Ok, will make some workaround for this.

Thank you