Can't find project or library

[David]

Hi Group,

I have copied files to Lexar memory stick, some of which contain code.
I have a fairly new laptop, running Windows Vista 64 bit. Excel is fully
installed and runs alright on it. I have recorded some simple Macros and they
run fine.

When I try and run a macro off the Lexar, I get a message ""Compile Error:
Can't find project or library". Just tried savings the file to the laptop and
running the macro, but it still gave me the message.

Any ideas?

Thanks,
David

 

[Tim Zych]

That error is usually related to MISSING reference(s) in VBE's Tools ->
References.

 

[David]

Hi Tim,

Thak you for your help. I do need to reference the Addin Solver, which was
newly added to this module. The problem I am having now is that in this 64
bit version of Vista, Excel is not finding the Addins!

If I use Add-In Manager, Excel does not see the Addins and I do not see a
way to change how the Manager looks. I guess it must be looking in the wrong
directory, the list simply does not exist.

Anyone out there using 64 bit? Know how to change the directory it is
looking in? When I use Explorer I find Solver.xla and Solver32.dll in Program
Files(x86)/Microsoft Office/Office11/Library/Solver, but as I mentioned, from
a Module Addins/Add-In Manager..., the dialog box find nothing.

Thanks,
David

 

[David]

Hi Again,

In the module, it appears I must reference the Solver.dll,
Tools/References/, which yields a very long list, but none in the list is
Solver. Browse, leads to a search, but when I select Solver.dll, I am not
allowed to add it to the list in the "References -VBAProject," "Available
References:" dialog box.

I am at a loss. Any help would be appreciated.

Thanks,
David