Jim,
I took a recently compiled/saved Excel 2003 addin to Excel 2000 giving the
same error and checked the references. The "Ref Edit Control" reference is
missing and the line triggering the error is: "OriginalWorkbook =
ActiveWorkbook.Name"
What's interesting is that I have sent the same addin to a friend running a
non SP3 Excel 2003 and he gets the error.
When I look at the DLL location for this reference, it points to the wrong
folder, ie ...\OFFICE11\REFEDIT.DLL. If I look at a backup of the same addin
compiled with Excel 2000, the DLL location for this reference seems right
....\office\refedit.dll, thus not missing.
Could it be possible that SP3 changed the location of that DLL? Which would
explain why it doesn't work anymore for Excel 2000 or non SP3 Excel 2003?
Thank you.
Eric
"Jim Thomlinson" <James_Thomlinson@owfg-Re-Move-This-.com> wrote in message
news:176F03D1-86EE-42AD-83BC-(E-Mail Removed)...
> Do your addins still compile on a 2000 machine? As a guess when you got
the
> upgrade it has changed a reference such as Microsoft ActiveX Data Objects
or
> such. On the 2000 machine try to compile. Also look at the Tools ->
> References and look for anything marked missing.
> --
> HTH...
>
> Jim Thomlinson
>
>
> "Eric" wrote:
>
> > Hello,
> >
> > I have been using Excel 2000 & 2003 to write macros and addins that
would
> > run on both Excel 2000 & 2003. Recently I have install SP3 on my Excel
2003
> > machine and now whenever I save my addins with this version it does not
run
> > anymore in Excel 2000. I now get the message: "Compile error in hidden
> > module: ModuleName".
> > I Googled the error and the only solution I found was to update Adobe
> > Acrobat, solution definitely not related to my problem...
> >
> > Any idea?
> >
> >
> > Thank you.
> >
> > Eric
> >
> >
> >
|
Similar Threads
