View Single Post
  #11   Report Post  
Posted to microsoft.public.excel.programming
ExcelMonkey[_190_] ExcelMonkey[_190_] is offline
external usenet poster
 
Posts: 172
Default Comple Error Cannot Find Project or Library

So type this in Run Window

RegSvr32 Mscal.osx


-----Original Message-----
The end user would have to RegSvr32 the control before

using it
in Excel. Go to the Windows Start menu, choose Run, and

enter

RegSvr32 "full_filename_of_control"


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




"ExcelMonkey" wrote

in
message ...
So if the user is missing the Microsoft Calendar Control
8.0, can I simply send him the Mscal.ocx Active x file

and
have him browse to it in VBA. Then try and open the
project again?



-----Original Message-----
No. and not that error.

--
Regards,
Tom Ogilvy

"ExcelMonkey"

wrote
in message
.. .
If the routine was originally written in Excel 2000

not
using Option Explicit would this cause problems in

Excel
2003? That is, none of the variables in the routines

have
been declared. Could this be causing a problem in a

newer
version of Excel?



-----Original Message-----
I have a client that cannot open one of our models.
Sounds like the file is crashing right off opening.

He
is
getting a comple error that says "cannot find project

or
library" This client has run these type of

spreadsheets
before. He is using Excel 2003. We are using Excel
2000. The model opens up properly on my machine.

In Excel the client has his add-ins installed.
Analysis Toolpack
Analysis Toolpack VBA

In VBA his tools/references have:
Visual Basic for Applications
Microsoft Excel 11.0 Library
OLE Microsoft Office 11.0 LibraryAutomation
Microsoft Forms 2.0 Object Library

The only difference that I can see if that we are

using
the 9.0 library for Excel and Office.

Why would a later version of Excel not run this file?
.



.



.