View original (French)

VBA no longer recognizes special characters

LeGrandDuc -  
 LeGrandDuc -
Hello,

Thank you in advance for your attention.

I have something that has changed in my Excel and I don't know exactly what.
I have a table with letters with accents in the column names. And now my VBA code no longer recognizes these characters and when I display "procédé" in a message I get proc?d?.

Can you tell me how to fix this problem?

Thank you very much

Configuration: Windows / Chrome 80.0.3987.149

3 answers

  1.
    eriiic Posted messages 24581 Registration date   Status Contributor Last intervention   7 281
     
    Hello,

    I have no idea about your problem but please specify which version of Office and what OS you are using.
    With Mac, which behaves strangely with accents, and 365 being temperamental, it might open some avenues.
    When you say "table", do you mean a structured table or not?
    Also, please include the code snippet in question or a working file (anonymized and reduced to the essentials).
    Eric

    By constantly trying, we eventually succeed.
    So the more it fails, the more chances we have that it will work. (the Shadoks)
    In addition to thanking, (yes, it’s done!!!), remember to mark it as resolved. Thank you.
    0
    1. LeGrandDuc
       
      I'm sorry, it's my first draft. I'm on Windows 10 with Office v14, which I think is 2010. In this context, before I could make a message like: msgbox "The file is copied!" and the message display was correct.

      I changed the administration language in Windows and made some changes that I thought I had corrected after noticing the problem. But either everything hasn't returned to the way it was before, or Windows didn't remodify everything, or I forgot a setting. But there are so few that it's hard to make a mistake on that side.

      But since then, my Excel VBA code above shows me "The file is copied?!"

      For the table, I had a column called "Modified Register," and when I referenced it, it worked before, but not anymore. I had to change its title to a title without accents.

      Thank you.
      0