VBA File Not Found error?

[davegb]

I have a client who has about 70 files connected to a common resource
pool. I created some macros in some of the files. I also deleted some,
and moved some around. When I open 2 of the files, I get a message box
saying "VBA Error, File Not Found" twice. I get the same message twice
when I open the VBE. I think it may be looking for a module that I
moved or deleted. None of the macros call an external file. Any ideas
on what is causing these messages?

David G. Bellamy
Bellamy Consulting

 

[Rod Gill]

Hi,

Is there any code in the Project_Open event?

--
For VBA posts, please use the public.project.developer group.
For any version of Project use public.project
For any version of Project Server use public. project.server

Rod Gill
Project MVP
For Microsoft Project companion projects, best practices and Project VBA
development services
visit www.projectlearning.com/

 

[davegb]

Thanks for your reply. None of the macros have a Project_Open or
Project_Close event. I should have mentioned I get the error message
(twice) when I close the file as well.

Dave B

 

[Mark Durrenberger]

Dave,
Just a thought,
Check your "references"

(In the VB Editor "tools/Reference") see what is checked and that the
corresponding files exist...

Mark



--
_________________________________________________________
Mark Durrenberger, PMP
Principal, Oak Associates, Inc, www.oakinc.com
"Advancing the Theory and Practice of Project Management"
________________________________________________________

The nicest thing about NOT planning is that failure
comes as a complete surprise and is not preceded by
a period of worry and depression.

- Sir John Harvey-Jones

 

[davegb]

Thanks for the reply, Mark. Under "Tools, References", I have Visual
Basic for Apps, MS Project 11.0 Object Library, OLE automation, MS
Office 11.0 Object Library, MS Forms 2.0 Library checked. I unchecked
the ones it would let me (OLE automation and MS Office Object
Library). When I tried to uncheck the others, I got a message telling
me I can't remove them because they're in use.
After deselecting the 2, I closed and saved the file, still getting
the File Not Found errors, then reopened it, and still got the errors.
Did I do this right? Is there another way to check it, or does this
indicate that this is not the problem?

Dave B.

 

[Mark Durrenberger]

It indicates that the references are not the problem....

Hrmm...
Puzzling.

When you put the troublesome MS project file on another system, do you still
get the error?
Are there any external references in Project (like an Inserted Project)
Mark

--
_________________________________________________________
Mark Durrenberger, PMP
Principal, Oak Associates, Inc, www.oakinc.com
"Advancing the Theory and Practice of Project Management"
________________________________________________________

The nicest thing about NOT planning is that failure
comes as a complete surprise and is not preceded by
a period of worry and depression.

- Sir John Harvey-Jones

 

[davegb]

Thanks, Mark.
Yes, the message appears on other computers besides this one. And no,
there are no external files with this file, other than the resource
pool, which is connected and open. This is not the same error message
I get when I have an external link and Project can't find the other
file. I'm 90% sure it is something in VBA. But.....

Dave B

 

[Mark Durrenberger]

can you share the file with me. I'm really curious (I've got plenty of other
work I *should* be doing but solving little techie problems is much more fun


send it to "mrd" at the domain in my footer

M

--
_________________________________________________________
Mark Durrenberger, PMP
Principal, Oak Associates, Inc, www.oakinc.com
"Advancing the Theory and Practice of Project Management"
________________________________________________________

The nicest thing about NOT planning is that failure
comes as a complete surprise and is not preceded by
a period of worry and depression.

- Sir John Harvey-Jones

 

[davegb]

Mark,
I finished my engagement there, at least for now. I can get the file
sent to me. Will take a day or 2. Will forward it to you. I'm dying to
figure this one out. Now it's become a matter of personal honor!
Dave B.