VBA & Macro Problems

Fix an Excel Macro That Opens Internet Explorer in WPS Office

Natalie TaylorNatalie Taylor Nov 13, 2026 869 views

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.

Fix an Excel Macro That Opens Internet Explorer in WPS Office
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.
Before you start

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.

Solution 1Recommended

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.

1
Open the VBA editor

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.

2
Locate the Internet Explorer code

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").

3
Change the code to use the default browser

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.

4
Save and test the macro

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.

Replace the Internet Explorer call with the default browser or Microsoft Edge
Macro updated: The macro now opens the signing page in a supported browser instead of retired Internet Explorer.
Direct WPS solution

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. 1. Open the workbook in WPS Office Spreadsheets: Start WPS Office, open the affected .xlsm or .xls workbook, and enable macros if prompted.
  2. 2. Open the VBA editor: Click the Developer tab and select Visual Basic, or press Alt+F11 to open the VBA project.
  3. 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. 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. 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.
Edit VBA macros without Microsoft ExcelFull compatibility with .xlsm and .xls macro-enabled workbooksLaunch Microsoft Edge or the default browser instead of retired Internet ExplorerFree, lightweight Office suite with a familiar ribbon and macro editor
microsoft office alternative - wps office

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.