HELP!!! Macro doens't run on clients maschine

[Michael]

Hello.

I programmed a macro in vba excel 2003 (english language). This macro shifts
columns to the correct position and adds some static data. Afterwards the
data gets exported into a txt-file. (nothing complicated)

I macro runs on the machines in our office (germany). we use the ms office
package 2003 english language. the costumer uses the same version in fance.
english language too.

when i start the macro in the machine of the client excel aborts the macro
and displays the error: "procedure and/or instance doesn't exist" and marks
"(CHR(10))" in the source code. I uses (CHR(10)) to get a carriage-return in
the messagebox.

When I cut all (CHR(10)) the macro aborts too with the same message and
marks the i from "for i = 1 to 9".

Could it be that there a different object bibliotheka files?? Or do you see
any other solution? I think I am not the first person that programs macros in
germany for french companier.

So I would be happy to get you reply.

Many thanks in advance.

Michael

 

[Bob Phillips]

I would first check the other machines that it doesn't work on in the VBIDE
and check Tools>References, and if any items are marked MISSING, uncheck
them.

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Michael]

Hi Bob,

Thanks for you answer.

I called the client and compared his and my prefs in the VBA IDE under
tools>references. We both have the same.

Do you have any further idea?

Thanks
Michael

 

[Michael]

CAN ANYONE GIVE ME ANOTHER ADVISE???

"