Fix an Excel Macro That Opens Internet Explorer in WPS Office
Question details
The user needs to update an Excel VBA macro that opens Internet Explorer for a signing process because Internet Explorer is retired and unsupported.

- Product
- WPS Office Spreadsheets
- Device & OS
- Windows 10 or Windows 11
- Scenario
- A signing process relies on an Excel VBA macro that launches Internet Explorer, but the browser is no longer available on current Windows systems.
- Observed behavior
- The macro fails or cannot open Internet Explorer, blocking the signing workflow.
Confirm that the workbook is saved as a macro-enabled file (.xlsm or .xls). In WPS Office Spreadsheets, enable the Developer tab so the Visual Basic editor is available for the macro update.
Replace the Internet Explorer call with the default browser or Microsoft Edge
Best for macros that directly create an Internet Explorer object; it removes the retired Internet Explorer dependency from the VBA code.
Because Internet Explorer is retired, VBA code that uses InternetExplorer.Application must be changed. The safest replacement is to hand the signing URL to the default browser or directly to Microsoft Edge.
Open the macro-enabled workbook in WPS Office Spreadsheets, select the Developer tab, and click Visual Basic or press Alt+F11 to open the VBA editor.
In the Project Explorer, open the module that contains the signing macro and find the line that creates Internet Explorer, such as CreateObject("InternetExplorer.Application").
Replace the Internet Explorer automation block with a supported browser call. For example, use a Shell command or ThisWorkbook.FollowHyperlink with the signing URL to open the page in the system default browser.
Save the workbook as an Excel Macro-Enabled Workbook (.xlsm), run the macro, and confirm that the signing page opens in Microsoft Edge or the current default browser.

Set Microsoft Edge as the default web browser in Windows
Use this if the macro already launches the default browser, but Windows still resolves web links to Internet Explorer or another browser.
Update the Excel VBA Macro in WPS Office to Open Microsoft Edge
Open the affected workbook in WPS Office Spreadsheets, edit the VBA macro that still calls Internet Explorer, and replace it with a default-browser or Microsoft Edge launch command. WPS Office preserves your macro-enabled Excel files so the signing process works again without Internet Explorer.
- 1. Open the workbook in WPS Office Spreadsheets: Start WPS Office, open the affected .xlsm or .xls workbook, and enable macros if prompted.
- 2. Open the VBA editor: Click the Developer tab and select Visual Basic, or press Alt+F11 to open the VBA project.
- 3. Locate the Internet Explorer code: In the Project Explorer, find the module for the signing macro and locate the CreateObject("InternetExplorer.Application") call or Internet Explorer navigation code.
- 4. Replace the browser call: Substitute the Internet Explorer automation code with a Shell command or FollowHyperlink statement that opens the signing URL in Microsoft Edge or the system default browser.
- 5. Save and test: Save the file as a macro-enabled workbook, run the macro, and confirm the signing page opens in Microsoft Edge instead of Internet Explorer.

Frequently Asked Questions
Why does my Excel macro still try to open Internet Explorer?
The macro likely contains a CreateObject("InternetExplorer.Application") call or a web link associated with Internet Explorer. Because Internet Explorer is retired, those commands fail on current Windows systems.
How do I change the VBA code to open Microsoft Edge instead of Internet Explorer?
Open the VBA editor in WPS Office Spreadsheets or Excel, locate the Internet Explorer object, and replace it with a Shell command or FollowHyperlink statement that passes the signing URL to the default browser.
Can I edit Excel VBA macros in WPS Office?
Yes. WPS Office Spreadsheets can open macro-enabled workbooks and includes a VBA editor. Enable the Developer tab, open the Visual Basic editor, and modify the macro code.
What should I do if the macro still fails after changing the code?
Set Microsoft Edge as the default browser in Windows Settings > Apps > Default apps, verify the workbook is saved as .xlsm, and check the exact error message and macro code.




