ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   VBA complilation error (https://www.excelbanter.com/excel-programming/320881-vba-complilation-error.html)

+ Z +

VBA complilation error
 
I passed from Office 2000 po to 2003 pro.

When I lunch one of my VBA prog. it stops on line :
"SolverReset"
and gives the following erro message :
"Project or bibliotheque not found"

What should I do ? --- Thanks for advance



Chip Pearson

VBA complilation error
 
You need to set a reference to the Solver add-in. In VBA, go to
the Tools menu and choose References.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"+ Z +" wrote in message
...
I passed from Office 2000 po to 2003 pro.

When I lunch one of my VBA prog. it stops on line :
"SolverReset"
and gives the following erro message :
"Project or bibliotheque not found"

What should I do ? --- Thanks for advance





gocush[_29_]

VBA complilation error
 
The program is looking for "SolverReset" but not finding it.
If this is a Macro which is in one of your VBA modules, then remove the
quotation marks: SolverReset
If not, can you tell us what "SolverReset" is?

PS My computer sometimes lunches my programs. :)

"+ Z +" wrote:

I passed from Office 2000 po to 2003 pro.

When I lunch one of my VBA prog. it stops on line :
"SolverReset"
and gives the following erro message :
"Project or bibliotheque not found"

What should I do ? --- Thanks for advance




Tom Ogilvy

VBA complilation error
 
another thing to look at: (it restates what you have been told, but may be
useful)

http://support.microsoft.com/support...ver/solver.asp
Creating Visual Basic Macros that Use Microsoft Excel Solver

--
Regards,
Tom Ogilvy

"+ Z +" wrote in message
...
I passed from Office 2000 po to 2003 pro.

When I lunch one of my VBA prog. it stops on line :
"SolverReset"
and gives the following erro message :
"Project or bibliotheque not found"

What should I do ? --- Thanks for advance






All times are GMT +1. The time now is 05:43 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com