Excel 2010 – Excel 2021 ?

Topic

New Reply

[WSMartinM]

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.

Reply | Quote

Replies

Martin,

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!

RG

PowerShell & VBA Rule!
Computer Specs

Reply | Quote

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

Reply | Quote