View original (French)

ConvNumberLetter function

Solved
CECO_6776 -  
Hello,

Please let me know how to make the ConvNumberLetter function appear in the list of Excel functions every time I open an Excel file?

Best regards

Configuration: Windows / Chrome 78.0.3904.70

2 answers

  1. ALS35
    Hello,

    You need to copy the module that contains it to the personal macro workbook, in the VBA window it's called PERSONAL.XLSB.
    When you close Excel, save this personal macro workbook.

    Best regards
    1. CECO_6776 Author
      Thank you ALS35 for your response.

      It works for the workbook I'm using, but when I open another workbook, I can no longer see this function. How can I make Excel remember it like the SUM function, for example?
      Best regards.
    2. ALS35
      Hello,

      I told you, you need to put this function in the personal macro workbook (PERSONAL.XLSB).
      How did you manage to put this function in your file?
      Otherwise, open your Excel file, press Alt + F11, this opens the VBA editor, in the left window you should see a folder VBAProject (the name of your file) with a subfolder Modules where you should find a module containing your concerned function.
      Do you also see a folder VBAProject (PERSONAL.XLSB)?

      Best regards
    3. CECO_6776 Author
      Thank you ALS35
      I did everything you asked, but when I open another file and want to use the same function, I have to redo the process to insert the macro for the workbook to take it into account.
      I want you to help me save it so that I can find this function in any new file I open.
      Here is the screenshot I have attached

      Best regards.
    4. ALS35
      Hello,

      I don’t see an attachment.
      So we can also save it as an add-in by following these instructions
      https://support.microsoft.com/fr-fr/office/cr%c3%a9er-des-fonctions-personnalis%c3%a9es-dans-excel-2f06c10b-3622-40d6-a1b2-b6748ae8231f?ui=fr-fr&rs=fr-fr&ad=fr
      1) Open a blank Excel file, insert your macro as usual then click "Save As" and choose "Excel Add-in (xlam)" as the type, then choose a filename that you like, for example "MyFunctions"
      2) Then open the Excel Options dialog (File Options), choose "Add-ins" and at the bottom right click "Go". You then check MyFunctions, your function should now be available for all Excel files

      Best regards
    5. CECO_6776 Author
      Wow!!!!! Thank you so much, it works now on all my spreadsheets that I open.

      Thanks again and best of luck!

      Sincerely.