Spreadsheet Troubleshooting

Troubleshooting

If you’re experiencing issues running the macro in the spreadsheet, follow these steps:
 

1. Check for Multiple Excel Instances

  • Ensure that only one instance of Excel is running. If other Excel files are open, the macro may not run properly.

     

2. Update Chrome & ChromeDriver

Make sure both Google Chrome and ChromeDriver are up to date. Here’s how:

  • Update Google Chrome:
    1. Open Google Chrome.
    2. Click the three-dot menu in the top-right corner.
    3. Go to Help > About Google Chrome.
    4. Chrome will automatically check for updates and install the latest version.
    5. Restart Chrome to finish the update.
  • Download the Latest Stable ChromeDriver:
    1. Visit the ChromeDriver download page.
    2. Download the “stable” version of ChromeDriver WIN32. Make sure you download WIN32 and not WIN64!
    3. Extract the ZIP file and get the chromedriver.exe file.
  • Update SeleniumBasic:

    1. Locate your SeleniumBasic folder.Replace the old chromedriver.exe file with the new one you downloaded.
    For a visual guide, see the video from 4:00 to 7:45: Watch the Video

     

3. Check .NET Version

Make sure you have the correct version of Microsoft .NET.
Run the script StartChrome.vbs to install any missing software.
It can be found in the following folder:
D:\Users\Jan\AppData\Local\SeleniumBasic\Scripts
(Remember to replace “D:” and “Jan” with your drive and username.)

4. Make sure macros are not disabled in your Excel

To make sure macros are not disabled in Excel, follow these simple steps:

  1. Open Excel.
  2. Go to the File tab in the top-left corner.
  3. Select Options at the bottom of the menu.
  4. In the Excel Options window, choose Trust Center from the list on the left.
  5. Click on Trust Center Settings.
  6. In the Trust Center window, select Macro Settings.
  7. Choose Enable all macros (or select Disable all macros with notification if you want to be prompted before disabling macros).
  8. Click OK to apply the settings, then OK again to close the Excel Options window.

Now, macros should be enabled in your Excel workbook.

5. Reinstall SeleniumBasic

If the above steps don’t work, try uninstalling and reinstalling SeleniumBasic.