View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.programming
Alain79[_3_] Alain79[_3_] is offline
external usenet poster
 
Posts: 13
Default Problem in compiling code containing "$" char

Yes you're right
I was trying ALT 167 that gives º while ALT 0167 really give §
Thanks for that...

I can effectively change my code that way and test the result...
but this does not prevent me from having to face the same problem with some
other Char such as with the french "é" and it is not that comfortable to
change this letter everywhere it is used by ALT 0XXX especially when it is
inside a name...
I have started to analyse some ASCII Tables above 128 and the one I have got
supposed to be the most used one does not have the § !!!
If you know more about that, thanks
Alain

"alf bryn" wrote in message
...
Hi Alain79

Have you tried <Alt 0167, on my PC (Excel 2002 Enlish version) I get §

"Dave Peterson" wrote in message
...
whoops. Didn't see the existing replies.

Alain79 wrote:

In a big Excel xla application I have some functions that goal is just

to
detect if the character "§" is not in a string inside a specifc cell -

up
to
now no problem...

This .xla Addin application is distributed on several countries - most

of
PC
running the application are
= either Win2000 US plus Office 2000 US
= or Win 2000 US plus office 2003 US
= or Win XP US plus Office 2003 US

Problem description: on some machine (only a few), the xla application
cannot be compiled, in fact if you open the microsoft visual basic
editor,
you can see that the "§" character has been replaced by a "?" that
produces
the compiler problem...

Have you an idea for the reason of this behaviour?
We have already made an analysis of the code page conversion table of

the
PC
that have the problem and have seen that its content was identical to
another PC without any problem...

Thanks if you can help
Alain


--

Dave Peterson