Cant find project or library макрос ошибка excel

So I’m having to run someone else’s excel app on my PC, and I’m getting «Can’t find Project or Library» on standard functions such as date, format, hex, mid, etc.

Some research indicates that if I prefix these functions with «VBA.» as in «VBA.Date» then it’ll work fine.

Webpages suggest it has to do with my project references on my system, whereas they must be ok on the developer’s system. I’m going to be dealing with this for some time from others, and will be distributing these applications to many others, so I need to understand what’s wrong with my excel setup that I need to fix, or what needs to be changed in the xls file so that it’ll run on a variety of systems. I’d like to avoid making everyone use «VBA.» as an explicit reference, but if there’s no ideal solution I suppose that’s what we’ll have to do.

• How do I make «VBA.» implicit in my project properties/references/etc?

-Adam

I have experienced this exact problem and found, on the users machine, one of the libraries I depended on was marked as «MISSING» in the references dialog. In that case it was some office font library that was available in my version of Office 2007, but not on the client desktop.

The error you get is a complete red herring (as pointed out by divo).

Fortunately I wasn’t using anything from the library, so I was able to remove it from the XLA references entirely. I guess, an extension of divo’ suggested best practice would be for testing to check the XLA on all the target Office versions (not a bad idea in any case).

answered Mar 4, 2009 at 22:44

answered Jul 11, 2009 at 14:14

Even when all references are fine the prefix problem causes compile errors.

What about creating a find and replace sub for all ‘built-in VBA functions’ in all modules,
like this:

replace text in code module

e.g. «= Date» will be replaced with «= VBA.Date».

e.g. » Date(» will be replaced with » VBA.Date(» .

(excluding «dim t As Date» or «mydate»)

All vba functions for find and replace are written here :

vba functions list

answered Dec 4, 2020 at 22:30

For those of you who haven’t found any of the other answers work for you.

Try this:

Close out of the file, email it to yourself or if you’re at work, paste it from the network drive to your desktop, anything to get it to open in «protected mode».

Now open the file

DON’T CLICK ANY ENABLE EDITING OR THE YELLOW RIBBON

Go to the VBA Editor

Go to Debug — — Compile VBA Project, if «Compile VBA Project» is greyed out, then you may need to click the yellow ribbon one time to enable the content, but DO NOT enable macros.

After you click Compile, save, close out of the file. Reopen it, enable everything and it should be OK. This has worked for me 100% of the time.

answered Nov 3, 2021 at 19:27

answered Feb 5, 2018 at 10:47

answered Oct 9, 2019 at 8:10

I’ve had this error on and off for around two years in a several XLSM files (which is most annoying as when it occurs there is nothing wrong with the file! — I suspect orphaned Excel processes are part of the problem)

The most efficient solution I had found has been to use Python with oletools
https://github.com/decalage2/oletools/wiki/Install and extract the VBA code all the modules and save in a text file.

Then I simply rename the file to zip file (backup just in case!), open up this zip file and delete the xl/vbaProject.bin file. Rename back to XLSX and should be good to go.

Copy in the saved VBA code (which will need cleaning of line breaks, comments and other stuff. Will also need to add in missing libraries.

This has saved me when other methods haven’t.

YMMV.

answered Sep 21, 2020 at 7:50