Supporting Older Versions of Windows and Office: Launching VBA Excel with Internet Explorer

As developers of add-ins for Microsoft Office, it is essential to ensure compatibility with various versions of both the operating system and the office software. With the rise of newer browsers, the landscape has changed significantly since the days of Internet Explorer (IE). However, supporting older versions of Windows and Office remains crucial, especially when it comes to embedding browser controls within your add-in.

The Shift Away from Internet Explorer

It's worth noting that Microsoft's Script Lab tool no longer supports Internet Explorer. Moreover, AppSource, which tests combinations of platforms and Office desktop versions that use IE, now only issues a warning if the add-in does not support this older browser. The good news is that even though the add-in may not be rejected by AppSource, it still needs to function properly in these configurations.

Office on the Web's Transition

In another significant change, Office on the web no longer opens in Internet Explorer. This shift has far-reaching implications for add-in developers who must adapt their code to accommodate the newer browser versions.

Supporting Legacy Combinations

Despite these changes, some combinations of platforms and Office versions still rely on the webview control that comes with Internet Explorer 11 to host add-ins. As explained in Browsers used by Office Add-ins, perpetual versions through Office 2019 may continue to use this older browser.

Best Practices for Launching VBA Excel

To ensure a smooth experience for your users, it is recommended that you provide a graceful failure message when launching your add-in in the Internet Explorer webview. This approach will help minimize issues and allow users to work effectively with your add-in, even if they are using older versions of Windows and Office.

In conclusion, supporting older versions of Windows and Office remains an essential consideration for add-in developers. By understanding the changes taking place and adapting your code accordingly, you can ensure a seamless experience for your users while also maintaining compatibility with legacy configurations.

Launch internet explorer vba excel