PDA

View Full Version : Why my Excel program doesn't work on other computer? Why?



jiura
10-19-2007, 02:09 PM
Hello to all!
I wrote an Excel Program with macros and today I have run it on the other computer. But it didn?t work!
When I start program, Excel gave me the message: ?Microsoft Forms. Could not load an object because it is not aviable on this machine?. But there is no any ?object? only lines with selecting Excel cells. When I want to run this code again Excel displays me such message: ?Compile error. Excel cannot find a project or library? And Excel selects VBA function ?Trim()? or ?Str()?!!! And I cannot received any help information about them!!! But when I create new workbook and write there any VBA code with this function all works!


I try to reinstall Excel on this computer, and I install full Excel version on it, but it doesn?t work
But I try to run my application on the third computer. All works perfectly
P.S. All computers have Office 2003
P.S. This program doesn?t contain any additional controls!



What is wrong?
Please tell me!

lucas
10-19-2007, 03:02 PM
in the visual basic editor go to tools - references and see if any of them say missing next to them..if it does then uncheck them and try it again.

can you post the code that is causing you this problem?

jiura
10-20-2007, 01:48 AM
I can't paste my code, becouse it's very large!
But I гивукыещщв your answer thank you! I will try it in two days on other computer!