Left-function causes compile error

[Jaymond Flurrie]

What do I miss when the basic left-function of VBA causes "Can't find project or library" error? I haven't personally faced this error yet, but my friend said on some computer my program causes such an error - and in that workbook I created myself, so it should have all the references I used - right? He said that VBA.Left works, so this is pretty interesting (and unheard for me) problem.

 

[Michael M]

One thing to check
Go to the VB editor ( ALT + F11)
Select tools / References and see if there any MISSING references
If there are any, have a look here on how to repair them

http://www.cpearson.com/excel/missingreferences.aspx

 

[Michael M]

One thing to check
Go to the VB editor ( ALT + F11)
Select tools / References and see if there any MISSING references
If there are any, have a look here on how to repair them

http://www.cpearson.com/excel/missingreferences.aspx

 

[Jaymond Flurrie]

Sounds like a good guess. I'll let you know if it was about that.

 

[Jaymond Flurrie]

Ok, solved this one and I feel this is important enough to share.

1) The problem was missing Solver add-in - VBA didn't know that whether "left" was in Solver or in VBA library, so it was impossible to know which one to take

2) My program didn't work in every Windows version. It seemed like Excel version mattered something too.

The solution? Make pretty darn sure that when you code for both 32-bit and 64-bit Windows that you have the Solver add-in in BOTH program files AND in program files (x32) folders!

Another option is to check Windows version by VBA, but still the idea is that your problem can more than easily be about "wrong" Program Files folder.