Forum Discussion

tgkreutz's avatar
tgkreutz
Copper Contributor
Nov 20, 2023

Excel VBA - migrating from Windows to macOS

I'm moving many Excel .xlsm files from Windows to an M2 MacBook Pro running Excel for Mac (Microsoft 365) and am wondering: 1) how much of my VB code will break, and 2) if the code might execute differently, but silently, i.e. generating incorrect results without flagging the incompatibility.  I found one minor discrepancy: spaces around the exponentiation operator (https://answers.microsoft.com/en-us/msoffice/forum/all/exponentiation-in-excel-vba-for-mac/9ce857cd-0f85-4d4b-adbb-fd4ec742d62b).

 

Has anyone compiled a list of differences between Windows and macOS Excel VBA?  Any suggestions, from macro to micro?  Many thanks in advance!

No RepliesBe the first to reply

Resources