Compile Error with when opening excel file from another machine

C

Corey

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....
 
C

Chip Pearson

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.


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

Corey

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.


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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Compile error when opend from other PC 3
Excel cannot find or read file 5
Downloading Dialog when opening files from Network 4
Compile error in hidden module : MenuHandling 3
Compile error in hidden module 8
Compile Error 3
Change code by code. Can you do that? 2
Compile error in hidden module 1

Top