Windows 10 IE is not working with old VBA code

0 votes

A few years back, I created VBA code to access a webpage in Internet Explorer and fill textboxes with information from an Excel file. Unfortunately, after I upgraded to Windows 10, this software is no longer functional. The page loads without a hitch, but the data cannot be entered into the textboxes. It only launches the website and then freezes (no data is entered).

Windows 7's IE still runs the software without any issues. I tried several computers running Windows 10 and the issue still persists.

I tried modifying the IE.Document-related code at the end.

All("Response 123").

IE.Document value

I attempted to use getElementById("Response 123") to copy the values from my Excel spreadsheet into the textbox, but nothing happened.

Sub test()
Dim IE As Object

WebAddress = ""

    Application.ScreenUpdating = False
    Application.Calculation = xlCalculationManual

  Set IE = CreateObject("InternetExplorer.Application")

  IE.Visible = True
  IE.Navigate WebAddress

  While IE.busy
    DoEvents  'wait until IE is done loading page.

  Application.wait (Now + TimeSerial(0, 0, 4))

  IE.Document.getElementById("Response_123").Value = ThisWorkbook.Sheets("Sheet1").Range("B5")
End Sub

I would expect the value in my Excel sheet at B5 to be copied into the textbox that has ID "Response_123" (obtained from right clicking textbox > inspect), but it does not copy anything and remains blank. Again, I have no problem getting my code to work in Windows 7.

Dec 24, 2022 in Others by Kithuzzz
• 33,140 points

1 answer to this question.

0 votes
I discovered the answer. The issue was just with IE's security settings; there is nothing wrong with the code above. They were originally set to Medium-High, so I modified them to Medium and the code executed without a hitch.
answered Dec 24, 2022 by narikkadan
• 58,640 points

Related Questions In Others

0 votes
1 answer

Create a User Account in Windows 10 with PowerShell.

Hi@akhtar, To create a new user account without ...READ MORE

answered Oct 7, 2020 in Others by MD
• 95,460 points
0 votes
0 answers
0 votes
0 answers

SEOPress plugin not working with Wordpress 5.7

An error of type E_ERROR was caused ...READ MORE

Feb 14, 2022 in Others by Kichu
• 19,050 points
0 votes
1 answer

'composer' is not recognized as an internal or external command in windows server

For anyone coming here from Google who ...READ MORE

answered Feb 17, 2022 in Others by Aditya
• 7,680 points
0 votes
1 answer

Retrieve Balance with VBA and Excel

This code should log you in, provided ...READ MORE

answered Sep 5, 2018 in Blockchain by digger
• 26,740 points
0 votes
1 answer

How to load file to Excel Power query from SFTP site

Currently, I don't think there is a ...READ MORE

answered Dec 3, 2018 in Power BI by Upasana
• 8,620 points
0 votes
1 answer

Using VBA Excel to create a gramatically correct list

The Excel AND function is a logical ...READ MORE

answered Feb 9, 2022 in Others by gaurav
• 22,970 points
0 votes
2 answers

How to copy a formula horizontally within a table using Excel VBA?

Hi so basically, create an adjacent column ...READ MORE

answered Feb 16, 2022 in Others by Edureka
• 13,630 points
0 votes
1 answer

Read .xls file with Python pandas read_excel not working, says it is a .xlsb file

Try: import openpyxl xls = pd.ExcelFile('data.xls', engine='openpyxl') df = pd.read_excel(xls) Recently, ...READ MORE

answered Dec 17, 2022 in Others by narikkadan
• 58,640 points
0 votes
1 answer

How do I run a VBA Sub routine continuously when working in a Workbook and not only when the Workbook is opened?

on Thisworkbook, put: Private Sub Workbook_Open() Call checkPW(True) End Sub Then ...READ MORE

answered Jan 14 in Others by narikkadan
• 58,640 points
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP