can't find project or library - compile error

[Meinfs]

I attempted to port my Excel macro to a Mac OS9 with MS
Excel 2001 and is also giving the compile error message -
can't find project or library."

I had done the same and was successful when I ported onto
my VAIO desktop but failed on my VAIO notebook. Both
computers are running Office XP and Windows XP home.

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).

Anyone out there who can help me with this? Or at least
point me to someone who can?

Thanks so much.

 

[J.E. McGimpsey]

I attempted to port my Excel macro to a Mac OS9 with MS
Excel 2001 and is also giving the compile error message -
can't find project or library."

I had done the same and was successful when I ported onto
my VAIO desktop but failed on my VAIO notebook. Both
computers are running Office XP and Windows XP home.

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).

Anyone out there who can help me with this? Or at least
point me to someone who can?

Does your macro have references to any Windows system calls?

 

[meinfs]

I do not know exactly what those Windows system calls are.
Looking at Tools=>references, I see that it's
"missing:solver.xla" I don't know why this is but it seems
to be the cause of the problem.

I did find a workaround though. It got rid of the compile
error after I placed a copy of the file that contains the
macros in the Add-in folder of Office. I wish there was a
better way.

My next problem is the mac version stops at various
commands that it apparently doesn't understand.

Is there a reference work out there that I can consult so
that I can convert windows commands and syntax to the mac
version? (web-based and free would be the best

Thanks!

 

[J.E. McGimpsey]

I do not know exactly what those Windows system calls are.
Looking at Tools=>references, I see that it's
"missing:solver.xla" I don't know why this is but it seems
to be the cause of the problem.

solver.xla is an add-in in the Value Pack:Office:Add-ins folder on
your install CD. Run the Value Pack installer. Any time you install
something from the Value pack you should reapply the 10.1.2, 10.1.4
and 10.1.5 updates, but that should be fairly quick (I think only
the 10.1.2 updater affects Solver, but I'm not positve - my updated
version is 10.1.0).

I did find a workaround though. It got rid of the compile
error after I placed a copy of the file that contains the
macros in the Add-in folder of Office. I wish there was a
better way.

My next problem is the mac version stops at various
commands that it apparently doesn't understand.

What errors are you getting? MacVBA is VBA5.0 - equivalent to
WinXL97. If you're running into VBA6 commands, take a look here for
workarounds:

http://support.microsoft.com/default.aspx?scid=kb;en-us;188007

Is there a reference work out there that I can consult so
that I can convert windows commands and syntax to the mac
version? (web-based and free would be the best

Check out "Differences between Excel VBA for Windows and Excel VBA
for the Macintosh" in VBA Help. There are *very* few actual syntax
differences - the FileFilter syntax in the GetOpenFileName comes to
mind.

There's no direct translation for ActiveX controls, which won't run
on a Mac. That you'll have to rewrite to use Forms controls

 

[Meinfs]

Thanks very much for the helpful suggestions!

I'll need to learn more about Forms control and how to
use them in lieu of Active-X controls.