macro compile error in 2007 (not in 2010)

**rvrajendra** · 03-19-2012, 05:38 AM

Hi

I have a macro developed in excel 2010. The macro contains left,right,dir functions.

When I run in 2010 its fine, but the same macro when run in excel 2007. I am getting compile error

Complie error: Cant find project or library.

Please let me know what reference I need to add.

**Firefly2012** · 03-19-2012, 05:42 AM

Hi

in the VBE go Tools>References and check for anything listed as MISSING. Uncheck those and try re-running.

**mrice** · 03-19-2012, 05:44 AM

If you look in the list of references in 2007 (Tools - References), the missing one should have the word MISSING in front of it.

**rvrajendra** · 03-19-2012, 06:03 AM

Should I check or uncheck

**Firefly2012** · 03-19-2012, 06:05 AM

Originally Posted by Firefly2012

Hi

in the VBE go Tools>References and check for anything listed as MISSING. Uncheck those and try re-running.

Uncheck them

**buran** · 03-19-2012, 06:12 AM

Well, it's not certain that it will solve the problem, assuming that the macro needs the references to the specified library, i.e. it will just replace one error with another...