1. Forum
  2. Usenet
  3. MICROSOFT.PUBLIC.EXCEL

  • Re: Execute Excel spreadsheets and macros in French on a PC with Englis

    From Claus Busch@21:1/5 to All on Sat Feb 12 18:47:04 2022
    Hallo,

    Am Sat, 12 Feb 2022 18:34:59 +0100 schrieb DAN:

    When I open a spreadsheet I can read the data, but all macros fail because the
    code and formatting parameters are for a French version. (Swiss-French)

    It is not an option that I modify the code to English, because other people in
    the association continue to access it on French versions of Windows + Excel.

    VBA code must be written in English.

    Regards
    Claus B.
    --
    Windows10
    Microsoft 365 for business

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Ammammata@21:1/5 to All on Mon Feb 14 08:39:54 2022
    Il giorno Sat 12 Feb 2022 06:34:59p, *DAN* ha inviato su
    microsoft.public.excel il messaggio news:ofrf0h1ognklqcrehtsav6apdq4ol2vr4o@4ax.com. Vediamo cosa ha scritto:

    It is not an option that I modify the code to English

    this sound quite strange, as per my experience formulas are stored using
    codes or tokens, so they change according to the language I'm using

    please note: if your VBA code BUILDS formulas as text and then stores these formulas in cells (horresco referens) then you're right, you must translate them

    --
    /-\ /\/\ /\/\ /-\ /\/\ /\/\ /-\ T /-\
    -=- -=- -=- -=- -=- -=- -=- -=- - -=-
    ........... [ al lavoro ] ...........

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)