Compile Error: Can's Find a Project or Library - Compatibility

[Bovey44]

I've developed several macros that include references to files/workbooks (open/close, read & write). I've provided the files and associated macros to another PC where the Microsoft Object Library is 14.0 while mine is 16.0.

I receive the error indicated in the name of this post -is the error "Compile Error: Can't Find Project or Library" caused by the difference in object library versions? And, if so - what can I do to alleviate the problem; thus, to get the macros to run on the other PC?

Thank you.

 

[RoryA]

The Office and Excel object libraries should not cause that error. What other references do you have set?

 

[Bovey44]

There are four references: Visual Basic For Applications; Microsoft EXCEL 16.0 Object Library; OLE Automation; Microsoft Office 16.0 Object Library - those are the ones on my PC where I developed the code. The other PC where I'm trying to run the code has the same except it's 14.0 for the EXCEL & Office Library.

 

[Bovey44]

I'm getting the compile error: can't find a project or library on open statements like this: Workbooks.Open Filename:="C:\A_CAMS_SO\LOG_SPOE=KRISTEN.xlsm"

 

[RoryA]

Those should not cause that problem, although it is the second post I have seen recently with this issue and those same 4 references. Any chance you can put the workbook somewhere for me to look at (eg Onedrive / Dropbox)? It doesn't need to have any data in it.

 

[Bovey44]

Thank you, Rory for following up on my request. I'm not up-to-date on using Dropbox or sharing via Onedrive - any other suggestions? An email with the file as an attachment would have been convenient.