dinobuiatti
04-04-2003, 05:48 AM
I have an EXCEL project with a few embedded objects such as a rich text box and labels. The macros fun fine on my machine but not on others.
When it fails, it gives the message "Compile Error Problem: Can't find project or library"
The weird thing is that it fails on the most innocous stuff like the "Date" function, assigning a character to an variable (a=chr(34)), etc
It appears that when moving the EXCEL project to another machine, none of this commands work and only in the spreadsheet.
Andy ideas would greatly be appreciated.
Thnx
Dino
andyomeagher
08-07-2003, 12:41 AM
Can relate to that, have same situation.
From Microsoft.Public.Excel.Programming group on Google, the only feedback I've seen has been pretty much work-arounds. One had a very familiar ring to my 'old' programming days where the suggestion was to export all of the code and import it into a new excel workbook.
We used to do similar stuff with Pascal programs and it did work. I'm not in a position to try this just yet on my app but if it won't cause too many hassles it might be worth a go...
dinobuiatti
08-07-2003, 06:14 AM
Can relate to that, have same situation.
From Microsoft.Public.Excel.Programming group on Google, the only feedback I've seen has been pretty much work-arounds. One had a very familiar ring to my 'old' programming days where the suggestion was to export all of the code and import it into a new excel workbook.
We used to do similar stuff with Pascal programs and it did work. I'm not in a position to try this just yet on my app but if it won't cause too many hassles it might be worth a go...
I figured out what my problem was. A "reference" was not enabled in the Visual Basic Editor.
Do the following:
1 - Go into the Visual BAsic editor (Alt+F11)
2 - From the menu go to Tools --> References
This is a list of the references used in your project. You need to check the appropriate references to use them. If you don't, you get the "Compile Error Problem: Can't find project or library".
As I remember, you should see the unchecked library with a missing or something so should be easy to figure it out. Let me know how you get on.
Good Luck
Dino