macro error "can't find project or library"
 

I attempted to port my Excel macros to another computer.
The migration was successful onto my VAIO desktop but
failed on my VAIO notebook. Both computers are running
Office XP and Windows XP home.
The error message is in the Visual Basic 6.3 app that
says it can't compile because it can't find the "project
or library." When I compared the "references in the
VBAPoject" used by the macro, they appear to be the same
in both computers (e.g. Excel 10.0 object library; Solver
and so forth -- about 6 of them).
I also attempted to port the macro to a Mac OS9 with MS
Excel 2001 and is also giving the same compile error
message.
Anyone out there who can help me with this? Or at least
point me to someone who can?
Thanks so much.

macro error "can't find project or library"
 

On the problem machine, after the error, in tools=References, do you see a
reference marked as MISSING.

--
Regards,
Tom Ogilvy

Meinfs wrote in message
...
I attempted to port my Excel macros to another computer.
The migration was successful onto my VAIO desktop but
failed on my VAIO notebook. Both computers are running
Office XP and Windows XP home.
The error message is in the Visual Basic 6.3 app that
says it can't compile because it can't find the "project
or library." When I compared the "references in the
VBAPoject" used by the macro, they appear to be the same
in both computers (e.g. Excel 10.0 object library; Solver
and so forth -- about 6 of them).
I also attempted to port the macro to a Mac OS9 with MS
Excel 2001 and is also giving the same compile error
message.
Anyone out there who can help me with this? Or at least
point me to someone who can?
Thanks so much.

macro error "can't find project or library"
 

Here's a thread that may help. It contains some tips by Rob Bovey to make sure
solver is available.

http://google.com/groups?threadm=015...0a% 40phx.gbl

Meinfs wrote:

Yes I do see "missing: solver.xla" right after attempting
to run the macro.
I can't figure out why it would not load it despite it
being there.

However, if I make sure that solver.xla has been loaded,
then the rest of the macro works. I also found a workaround
to this problem and that is if I put a copy of my file that
contains that macros into the library folder of Office,
where solver.xla resides, then it works. I do hope that
there's a better way though, than this.

**My next problem to solve is to port my macros to the Mac
version of Excel (ver 2001)** My first attempt got me
the same compile error message which I solved the same way
as I described above. Now I have to edit the commands and
variables in the VB code so that the Mac can understand
them. I read somewhere here that ActiveX-related commands
are a no-no in Mac. Oy. If only I had a book of
syntax-equivalence.

-----Original Message-----
On the problem machine, after the error, in
tools=References, do you see a
reference marked as MISSING.

--
Regards,
Tom Ogilvy

Meinfs wrote in message
...
I attempted to port my Excel macros to another computer.
The migration was successful onto my VAIO desktop but
failed on my VAIO notebook. Both computers are running
Office XP and Windows XP home.
The error message is in the Visual Basic 6.3 app that
says it can't compile because it can't find the "project
or library." When I compared the "references in the
VBAPoject" used by the macro, they appear to be the same
in both computers (e.g. Excel 10.0 object library; Solver
and so forth -- about 6 of them).
I also attempted to port the macro to a Mac OS9 with MS
Excel 2001 and is also giving the same compile error
message.
Anyone out there who can help me with this? Or at least
point me to someone who can?
Thanks so much.



.


--

Dave Peterson

macro error "can't find project or library"
 

There are good suggestions in that discussion! I will try
them out. Thanks for the link!!!


-----Original Message-----
Here's a thread that may help. It contains some tips by
Rob Bovey to make sure
solver is available.

http://google.com/groups?threadm=015...60%2465c682a0%
24a001280a%40phx.gbl

Meinfs wrote:

Yes I do see "missing: solver.xla" right after
attempting
to run the macro.
I can't figure out why it would not load it despite it
being there.

However, if I make sure that solver.xla has been
loaded,

.... sections edited out from this point ...