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

I would first check the other machines that it doesn't work on in the VBIDE
and check ToolsReferences, 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" wrote in message
...
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

Hi Bob,

Thanks for you answer.

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

Do you have any further idea?

Thanks
Michael

CAN ANYONE GIVE ME ANOTHER ADVISE???

"