Compile Error with when opening excel file from another machine

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Corey - 01 Apr 2007 23:26 GMT

I have quite a complex VB Excel file with many macros and Forms.
All works great on my PC, but when the file is opened from another users PC it immediately comes up
with a Copile error.

The VB line highlighed is :
Sheet1.Range("C16").Value = Format(Now, "mmmm yy")
With the [Format] Highlighted.

If i click OK, and try to run a macro i then get another Compile error.

Is there a way to fix this?
Both PC's re running Office XP and have ALL Excel components installed.

Corey....

Reply to this Message

Chip Pearson - 02 Apr 2007 00:36 GMT

In VBA, go to the Tools menu and choose "References". See if any are marked
"MISSING". If so, you can either uncheck them if they are not needed or you
can browse to the actual file if you know what it is.

Signature

Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting LLC
www.cpearson.com
(email on the web site)

>I have quite a complex VB Excel file with many macros and Forms.
> All works great on my PC, but when the file is opened from another users
[quoted text clipped - 11 lines]
>
> Corey....

Reply to this Message

Corey - 02 Apr 2007 00:57 GMT

Thanks Chip.

In VBA, go to the Tools menu and choose "References". See if any are marked
"MISSING". If so, you can either uncheck them if they are not needed or you
can browse to the actual file if you know what it is.

Signature

Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting LLC
www.cpearson.com
(email on the web site)

>I have quite a complex VB Excel file with many macros and Forms.
> All works great on my PC, but when the file is opened from another users
[quoted text clipped - 11 lines]
>
> Corey....

Reply to this Message

Rate this thread: