compile error HELP !

Hi experts,

I made an application on my pc (XP, Excel 2003)
I compiled my application and it works fine on this pc.

Then i copied the application to another PC (XP, Excel 2002) and tried to
start the application.
It did not work and i got the following messages

- compile error in hidden module
i went to VBA and put in the password and then i tried to compile the project
again. then i got the message
- cannot find project or library and the program stopped at a line with CHR
(13) in it.
i clicked OK and the program jumps to the menu extra, references, to Ref Edit
Control

Does anybody know what the cause of my problem could be ?
Thanks,
Pierre

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200512/1

after the error, go to Tools=>References in the VBE and you should find at
least on reference marked as MISSING. If so, you need to correct this
reference. If it is not needed, then uncheck it. (you might have to close
and reopen the file to do this). If you need it, then you need to use the
browse button to find the file referenced.

--
Regards,
Tom Ogilvy


"Pierre via OfficeKB.com" <u13950@uwe> wrote in message
news:58ebc8a4d6222@uwe...
> Hi experts,
>
> I made an application on my pc (XP, Excel 2003)
> I compiled my application and it works fine on this pc.
>
> Then i copied the application to another PC (XP, Excel 2002) and tried to
> start the application.
> It did not work and i got the following messages
>
> - compile error in hidden module
> i went to VBA and put in the password and then i tried to compile the
project
> again. then i got the message
> - cannot find project or library and the program stopped at a line with
CHR
> (13) in it.
> i clicked OK and the program jumps to the menu extra, references, to Ref
Edit
> Control
>
> Does anybody know what the cause of my problem could be ?
> Thanks,
> Pierre
>
> --
> Message posted via OfficeKB.com
> http://www.officekb.com/Uwe/Forums.a...mming/200512/1

Hi Tom,

You were right, i was missing ms office web components.
However, i would like to distribute my application throug several outlet
which all have different excel versions (all >2000). Is there a way to
prevent this from happening somewhere in the future ?
thanks,
Pierre

Tom Ogilvy wrote:
>after the error, go to Tools=>References in the VBE and you should find at
>least on reference marked as MISSING. If so, you need to correct this
>reference. If it is not needed, then uncheck it. (you might have to close
>and reopen the file to do this). If you need it, then you need to use the
>browse button to find the file referenced.
>
>> Hi experts,
>>
>[quoted text clipped - 16 lines]
>> Thanks,
>> Pierre

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200512/1

Perhaps use Late Binding:

http://support.microsoft.com/default...b;EN-US;244167
INFO: Writing Automation Clients for Multiple Office Versions

http://support.microsoft.com/default...b;en-us;245115
INFO: Using Early Binding and Late Binding in Automation

http://support.microsoft.com/default...b;en-us;247579
INFO: Use DISPID Binding to Automate Office Applications Whenever Possible

--
Regards,
Tom Ogilvy


"Pierre via OfficeKB.com" <u13950@uwe> wrote in message
news:58ed43538f6ee@uwe...
> Hi Tom,
>
> You were right, i was missing ms office web components.
> However, i would like to distribute my application throug several outlet
> which all have different excel versions (all >2000). Is there a way to
> prevent this from happening somewhere in the future ?
> thanks,
> Pierre
>
> Tom Ogilvy wrote:
> >after the error, go to Tools=>References in the VBE and you should find
at
> >least on reference marked as MISSING. If so, you need to correct this
> >reference. If it is not needed, then uncheck it. (you might have to
close
> >and reopen the file to do this). If you need it, then you need to use
the
> >browse button to find the file referenced.
> >
> >> Hi experts,
> >>
> >[quoted text clipped - 16 lines]
> >> Thanks,
> >> Pierre
>
> --
> Message posted via OfficeKB.com
> http://www.officekb.com/Uwe/Forums.a...mming/200512/1