Link to home
Start Free TrialLog in
Avatar of 3sdk5
3sdk5

asked on

excell2007 to 2010

Hi I have just upgraded to a new computer (windows 7 64) with office 2010 installed on it.

Previous one  xp pro 32 bit office 2007.

when I use a searchy marco compiled in excell 2007 it comes up with a error
"Compile Error"."Can't find object or library"

Attached is the cod for the macro.

Please help
thanks
search.txt
ASKER CERTIFIED SOLUTION
Avatar of Ingeborg Hawighorst (Microsoft MVP / EE MVE)
Ingeborg Hawighorst (Microsoft MVP / EE MVE)
Flag of New Zealand image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of 3sdk5
3sdk5

ASKER

Hi Thanks For getting back to me,
All are checked
Will it Matter if it is 32bit office??


Cheers
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of 3sdk5

ASKER

sorry for the delay  yes you were correct one was shown as missing.

cheers
Avatar of 3sdk5

ASKER

was a mistake with the tick