Error message - "Can't find project or libarary"

[sobrien1234]

My workbook was working fine yesterday but today I keep getting the error message "Can't find project or libraray" - the box has a heading "Microsoft Visual Basic for Application"

The file is quite large and has macros in it. I can't:
1. Save it anymore
2. Make changes before it says "not responding"
3. None of the macros work anymore

Any suggestions much appreciated.

Thanks

Seamus

 

[mole999]

that should be referenced from the VB window, > Tools > references and look for something with an X against it for not installed.

As for not working macros, first step is always to do a full restart. The not responding can be the directory targeted for save has stopped responding (often a network drive)

 

[sobrien1234]

that should be referenced from the VB window, > Tools > references and look for something with an X against it for not installed.

As for not working macros, first step is always to do a full restart. The not responding can be the directory targeted for save has stopped responding (often a network drive)

Thanks I tried the tool/reference and it just showed a blank box. I use a home computer but also dropbox where the file is stored. It's quite large file and will take a long time to rebuild. Any other suggestions?

 

[mole999]

you need refernce to Visual Basic for Applications, maybe this link can guide you a little > https://stackoverflow.com/questions/35460812/excel-vba-add-in-reference-not-listed

 

[Dryver14]

@mole999

I am current learning about using the scripting library, I see that you can create an object

for instance dim fso as object followed by set fso = CreateObject("Scripting.filesystemobject) which I think allows the user to use the code without having to activate the library.

My question is what's the norm for send the code out?

1. Create an object, or is it a case that if you send the workbook out with scripting library ticked then they will be able to use it.

 

[mole999]

from my experience I use libraries that are normally installed, (there is a thing called late binding that can be used), different versions have different capabilities, so something from 2016 may not run on 2010 or even 2013. It is also possible to force loading of libraries > https://stackoverflow.com/questions/9879825/how-to-add-a-reference-programmatically took me ages to develop this so I could make it work

 

[Dryver14]

Thanks.......More learning required