Cyberdude
10-05-2009, 12:25 PM
Gawd, I hope one of you guys can help me put life back into my Excel system. I have no idea what caused this to start happening, but now every time I execute a macro (seems like any macro) I get an error message like:
“Compile error. Can’t find project or library”, “Missing Personal.xls”, or “Missing ATPVBAEN.xla”. I looked at my list of references and if the file name is there, it’s written like: “Missing: Personal.xls” or “Missing: ATPVBAEN.xla” or both.
Both of these files reside at:
“C:\Program Files\Microsoft Office\Office\OFFICE11\XLSTART\Personal”.
I had a backup copy of Personal which I substituted for the old Personal, but that was no help. Because I have a large number of shared macros on Personal, I cannot use Excel until I can get it to load.
Both files are resident at the place that Excel expects them to be, so why can’t Excel load them?? Note that IF I see either of these files in the Reference list, it has “Missing” preceding it. So a fix does not include putting a check mark in the little box next to the name. It almost sounds like Excel is looking in a different place now for those files.
I would REALLY appreciate your help on this one. All my business activities revolve around Excel, so now I’m dead in the water!
Sid
“Compile error. Can’t find project or library”, “Missing Personal.xls”, or “Missing ATPVBAEN.xla”. I looked at my list of references and if the file name is there, it’s written like: “Missing: Personal.xls” or “Missing: ATPVBAEN.xla” or both.
Both of these files reside at:
“C:\Program Files\Microsoft Office\Office\OFFICE11\XLSTART\Personal”.
I had a backup copy of Personal which I substituted for the old Personal, but that was no help. Because I have a large number of shared macros on Personal, I cannot use Excel until I can get it to load.
Both files are resident at the place that Excel expects them to be, so why can’t Excel load them?? Note that IF I see either of these files in the Reference list, it has “Missing” preceding it. So a fix does not include putting a check mark in the little box next to the name. It almost sounds like Excel is looking in a different place now for those files.
I would REALLY appreciate your help on this one. All my business activities revolve around Excel, so now I’m dead in the water!
Sid