Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can't find project or library
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can't find project or library
That error is usually related to MISSING reference(s) in VBE's Tools -
References. -- Tim Zych www.higherdata.com Compare data in worksheets and find differences with Workbook Compare A free, powerful, flexible Excel utility "David" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can't find project or library
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 "Tim Zych" wrote: That error is usually related to MISSING reference(s) in VBE's Tools - References. -- Tim Zych www.higherdata.com Compare data in worksheets and find differences with Workbook Compare A free, powerful, flexible Excel utility "David" wrote in message ... 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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can't find project or library
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 "David" wrote: 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 "Tim Zych" wrote: That error is usually related to MISSING reference(s) in VBE's Tools - References. -- Tim Zych www.higherdata.com Compare data in worksheets and find differences with Workbook Compare A free, powerful, flexible Excel utility "David" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can't find project of library | Excel Discussion (Misc queries) | |||
Can't find project or library | Excel Programming | |||
Can't find project or library | Excel Programming | |||
Can't find project or library | Excel Programming | |||
Can't find project or library | Excel Discussion (Misc queries) |