• Excel 2010 – Excel 2021 ?

    • This topic has 2 replies, 2 voices, and was last updated 5 months ago.

    I have several Ex el 2010 workbooks with a lot of code.

    Am I going to have problems if I migrate to Excel 2021 ?

    Thanks in advance

    • This topic was modified 5 months, 1 week ago by WSMartinM.
    Viewing 1 reply thread
    • #2490425


      The only 2 problems I’ve encountered are:

      1. With OS level calls ( you have to change the function definitions to include the PtrSafe qualifier.
        Public Declare PtrSafe Function FindWindowEx Lib "user32" Alias "FindWindowExA" _
            (ByVal hWnd1 As Long, ByVal hWnd2 As Long, _
            ByVal lpsz1 As String, ByVal lpsz2 As String) As Long
      2. If you have custom menus you have to convert them to Ribbon menus. It’s pretty easy, just give it a google. Note: they’ll keep talkling about callbacks just a fancy name for a function call. I actually eliminate the generated code and make a direct call to the function involved rather than having a “callback” function that makes the call. Just eliminates some code. I use a free program called Office Ribbon Editor which makes the whole process pretty straight forward.

      May the Forces of good computing be with you!


      PowerShell & VBA Rule!
      Computer Specs

    • #2491556

      Thank you RG – I’m going to take the plunge !

    Viewing 1 reply thread
    Reply To: Excel 2010 – Excel 2021 ?

    You can use BBCodes to format your content.
    Your account can't use all available BBCodes, they will be stripped before saving.

    Your information: