excel - MS Access Can't Find Project or Library Error -

i working on access database built me use. familiar writing vba code perform functions, however, not @ versed in debugging errors.

there form in database allows me clean , manipulate data in files can select computer. uses folder main root supply form names of files located in folder. there button connected perform data clean , manipulations.

now background out of way, there error can't seem passed. looks if solve error, snowballs else. error "cannot find project or library." after going resources noticed there microsoft excel 15.0 object library missing. know relationship between error , access, well, how fix this?

this common problem in microsoft office vba. while can have more 1 cause, in case appears person developed solution using different version of office yours development of code. (i same error whenever move same application between office 2003 , office 2010 platforms.)

to fix problem:

1. in tools..references window, uncheck "missing: microsoft excel 15.0" reference.
2. scroll down list of references, arranged alphabetically. locate entry object library microsoft excel (which presume have on machine), version number different. check that.
3. recompile , save.

it nice if vba environment able provide more useful error diagnostic, i'm not sure how easy microsoft accomplish, given interoperation between vba , library uses venerable com technology: error recovery involve vba recognizing alternative, , attempt use library substitute.