In a standard module I have the following declarations for ShellExecute to allow its use in both 64 and 32bit versions of Excel
In Excel 2007 32-bit, there is no problem.Please Login or Register to view this content.
However, users with Excel 32-bit (build "16.0.12228.20100") as part of Office 365 receive a compile error. When manually compiling on one of these machines it highlights the vba7 declaration (above, in red).
Does anyone know why this is causing a compilation error in Excel 365 and how I can have declarations for both 32-bit and 64-bit?
Bookmarks