All Questions
Tagged with internet-explorer vba
1,230 questions
-1
votes
1
answer
88
views
Same code used in Internet Explorer navigate has different results
The issue that I'm facing is that in two different Excel macros in different Workbooks I use the Internet Explorer navigate with a string variable for the URL.
The codes are similar for the IExplorer ...
0
votes
0
answers
83
views
Need VBA code to retrieve ALL data from a webpage
I’m trying to retrieve a list of attendees to an event on a webpage. If I use a browser, to the webpage, right click, and choose View Page Source I can see the names of the attendees.
I need to do ...
- 3
1
vote
0
answers
68
views
Excel VBA IE click open a new window and nothing happens, with no error too
Despite I'm just an entusiast absolutelly non pro, I'm using with moderate success an Excel vba code to fill some forms of an intranet company procedure written in html/java and download some data ...
0
votes
0
answers
45
views
How do I Choose from this webpage dropdown in IE using VBA
I am trying to scrape a website using VBA and I cant seem to figure out how to select from the choices in a dropdown. It seems like the Options are hidden and only show in the HTML code one they are ...
- 11
0
votes
0
answers
36
views
Run-time error '91' object variable or with block variable not set "on executing second code"
Option Explicit
Sub cvt()
Dim ie As InternetExplorer
Dim doc As HTMLDocument
Dim url As String
Set ie = New InternetExplorer
Let url = "https://cvt.in.telstra.com.au/BILLQA/"
ie.Visible =...
0
votes
0
answers
85
views
VBA, Internet Explorer and Javascript
I'm currently working on a VBA automatisation between Excel Files and Oracle Data base via APEX using Internet Explorer but the last Oracle update give me some issues.
(I'm still using internet ...
0
votes
0
answers
92
views
unable to get the right object to set the windowState
I'm trying to put an IE window on the side of the screen as showed in this answer but I'm unable to get the right object to set the windowState
edit note: the code in the linked answer works with the ...
- 3,301
0
votes
0
answers
102
views
Get value from web document (intranet) input element with VBA
I'm having trouble getting the value from an input field called "due date"
Here is my HTML and VBA code.
I resolved error 462, but I can't retrieve certain data.
Actually I'm getting an ...
- 31
0
votes
0
answers
59
views
Using VBA to populate richtext field in browser
I am using the following code to paste text into a HTML document form. It works with normal text boxes but not with a rich text box.
IE.document.getelementId("ct100_ct138...T2").Value = &...
- 1
0
votes
0
answers
115
views
Using Excel vba to navigate through IE and menus of the site
enter image description hereI am a newbie trying to automate some routine procedures through Excel vba. But I can't access the HTML element that I want to click.I would like to click on the menu ...
- 1
0
votes
0
answers
52
views
Export all data to excel from this website
i'm a newbie in webscrapping and i need to do a code to export all data to excel from this website
to excel. without filtering or filtering every possibilities.
i have got the error
method "...
- 21
0
votes
1
answer
57
views
Automate IE via Excel. Dropdown "change" stopped working
2+ years ago I asked basically this same question (Automate IE via Excel to fill in a dropdown and continue) and it worked perfectly until a couple of months ago. The code that I previously used is ...
- 102
0
votes
1
answer
162
views
Runtime Error creating IE Object using Excel VBA
I'd like to get data from a website.
It runs the first time when I click on my created Sync button.
For the next click, it shows the error as below.
It got stuck at CreateObject, my code as below.
...
- 1
0
votes
1
answer
892
views
Extract data from an HTML table on a Web page into Excel
I need some help with taking data from website using vba. I have table in excel with etf ticker, link and price and using vba I try to take close price of yesterday from each link but the problem is ...
- 55
1
vote
1
answer
13k
views
Changing browser from internet explorer to Microsoft edge in VBA script
I have a code where I open an URL in "Internet Explore" using the following piece of code.
Dim IE As Object
Set IE = New InternetExplorerMedium
IE.Visible = True
IE.Navigate URL
now I ...
- 23
0
votes
0
answers
125
views
Internet Explorer object in Excel VBA. IE.Document.all("Name"). value not work
I use:
For Each ele In IE.Document.getElementsByTagName("input")
Debug.Print ele.Name; "-"; ele.Value
Debug.Print IE.Document.all("peticion.numeroPeticion").Value
...
- 15
0
votes
0
answers
86
views
autofill the box on the website and validating it
I would like to have the possibility to autofill the box on the website and validating it (Click OK) straight from the VBA code.
I've inspected the website and the situation looks pretty much like ...
- 1,384
0
votes
1
answer
134
views
To automatically print in excel but nothing happens
I am trying to use this code for the following:
When I click on a link in Excel it automatically prints, but nothing happens.
I have mozilla installed, the path is the same. Where could be the cause ...
- 26.8k
0
votes
1
answer
178
views
Web scraping - 'IWebBrowser2' failed
Currently, I have provided a dummy website below, and I was using the code below to navigate to the website and enter the value in the specific cell. After running this code, it navigates to the ...
- 1
1
vote
0
answers
363
views
Excel VBA integration with IE, getting an unusual error 462
I'm trying to use Excel's VBA to automate a task involving a website. Here's the relevant code I have:
Sub test()
Dim IE as Object
Set IE = CreateObject("InternetExplorer.Application"...
- 11
0
votes
1
answer
182
views
How to close a web message from IE VBA?
I,ve been dealing with a issue during my web scraping.
My problem is that when I click to "Submit" a form, it pops-up a web message that I've not been able to close.
I´ve already try the ...
0
votes
1
answer
59
views
I Get "object required" error when using getElementByID
I am trying to enter a Username into a text box Using getElementById. this generates an "Object required" Error
Dim Myid
Mypsw As String
Dim ie As InternetExplorer
Dim ErrCnt
On Error GoTo ...
0
votes
1
answer
97
views
How to select the element by VBA IE automation
I am not able to select the following text field using VBA
Please help
Html code
<input type="text" autocomplete="new-password" name="confirm bank loan account Number" ...
- 13
1
vote
1
answer
91
views
Extract element from html document with vba excel
I have this code below from HTML document, result of inspection object from site web.
I want to get the object <input name="username" value=""> with VBA Excel code.
<tr id=...
- 11
1
vote
1
answer
1k
views
Puppeteer / Excel VBA: how to scrape table data from website
I have used Excel VBA & IE to access website financial data tables for 15 years, but this is now obsolete. So I am trying to use Puppeteer on a Raspberry Pi to dump the website data to disk which ...
- 311
0
votes
1
answer
52
views
Clicking button on login page
I'm trying to automate the login at https://www.thewindpower.net/login_en.php and am able to fill out the username and password using:
.Text.Value = "xxxxxx"
.Password.Value = "xxxxx&...
0
votes
1
answer
104
views
Table scraping VBA
I have got the following code, which is supposed to scrape the table and print the result. I am expecting to get them into a table
County| Shropshire
Address| Adams Grammar School, High Street, ...
0
votes
1
answer
495
views
How do I fix Run time error. Automation Error
hello everyone I am facing this issue anyone please help me to fix this issue.
Public Sub DownloadFile()
Dim objIE As InternetExplorer, currPage As HTMLDocument, url As String
Dim elements
url = &...
- 27
-1
votes
1
answer
714
views
Automating Internet Explorer via VBA for Windows 11
I realise there are other threads for this but I coudnt see a complete answer for my circumstances after searching a few hours, just lots of "will try this or this"
I have a significant ...
- 19
0
votes
1
answer
93
views
IE not response to a checkbox ticked by a VBA code
I’m trying to write VBA code to control IE automatic extract data from a local intranet website . Everything work ok with the default setting of the website. However when i change the criteria of ...
- 1
0
votes
1
answer
523
views
Get text from web site
I'm trying to get the content of a web site and paste it onto a excel sheet.
Before trying to code something in VBA I was simply doing "Control + A" (to select ALL the content from the page ...
- 152
-3
votes
1
answer
151
views
Scrape data from multiple url in excel and save it in different row
getting url form sheet1 range a1:a1000 and after exporting saving data too sheet2
ie.navigate Workbooks("1000").Worksheets("sheet1").Range("A6").Value
Set ht = ie....
- 11
-1
votes
1
answer
52
views
How can I loop the script 1000 times to get the data in different cells and get URL value from different cells?
How can I loop the script 1000 times to get the data in different cells and get URL value from different cells?
Private Sub CommandButton1_Click()
Dim ie As InternetExplorer
Dim ht As ...
- 11
2
votes
0
answers
543
views
'Object doesn't support this property or method' error in VBA when using IE reference library to execute JS (MS Excel)
I am trying to execute some JS code inside my excel workbook, so I found out about the Internet Explorer & Microsoft HTML references, and I built this code with some inspiration from https://...
- 602
0
votes
1
answer
2k
views
VBA automate Edge Browser without downloading any external things
I have the below VBA codes to automate IE, and then extract the figures of the HTML table and populate the data to Excel table. Is it possible to do the same thing by automate Edge Browser? Since my ...
- 11
0
votes
0
answers
116
views
VBA_Web Scrape - Next Page
Login Issue [ Done ];
Table Data Scrape [ Done ]
I am currently stuck at how to
count no. pages to repeat data scrape. [ Solve ]
For Each HTMLTable In IE.Document.getElementsByTagName("li")(...
1
vote
1
answer
298
views
Why is VBA throwing Run Time Error 438 when using querySelector to click link on website?
I am trying to navigate through a website using a VBA macro. I have been successful so far adapting my code off of this answer, but have come upon a situation where I need to click on a "logout&...
- 63
0
votes
1
answer
113
views
Searching html element properties
I am trying to grab information from my company's booking engine to use in an Excel document. I am having trouble searching the HTML.
I am trying to check if it is on the login page or if it is ...
0
votes
1
answer
287
views
Importing Data from Login Required Websites to Excel using VBA macros
I want to ask the question above, I've looked all over the internet but found nothing. I also have tried to use the excel Get & Transform Data From Web, but it can't import anything as it required ...
- 1
0
votes
0
answers
117
views
Excel VBA - Type mismatch and object does not support this property or method
I have a very nerve wracking problem, the code worked just fine. After saving it and going back an hour after the code started to throw some errors at me. Type mismatch happens when I am checking if ...
- 33
0
votes
1
answer
59
views
Excel VBA InternetExplorer.document - Automation/unspecified error
I am new to the wonderful world of excel VBA. I am trying to scrape some data from our company page. As you can see in the picture I get the Automation/unspecified error. Any ideas? It does not matter ...
- 33
1
vote
0
answers
3k
views
vba code for sending texts from excel to whatsapp
I have previously used selenium webdriver for sending messages to whatsapp via VBA. But now, I need some pure vba codes to send text from excel sheet. What I discovered InternetExplorer does not ...
- 711
0
votes
1
answer
380
views
Trouble with copy-pasting a web page through Excel VBA
I'm having trouble selecting the entire webpage, copying it, and pasting onto the excel spreadsheet using the code below through VBA. Also, I'm sure I haven't properly put instructions for the copy-...
- 45
0
votes
1
answer
37
views
how to click on "a" tag or button on a webpage using <Table> and <td> and <tr>?
I am trying to click on the first Ref number "182931" with name of Request ID "350-ageing replica" only out of two report i trying forloop in excelVBA & tried many method but ...
1
vote
1
answer
487
views
Microsoft will shutdown IE starting June 15, will vba code that uses InternetExplorer and HTMLDocument still work after the shutdown date?
I have a vba program that uses InternetExplorer and HTMLDocument object. Since Microsoft has already announced that it will shutdown internet explorer starting June 15, 2022. I am just worried will ...
- 63
0
votes
0
answers
896
views
How do I change this VBA code from internet explorer to chrome?
I have this code and would like it to convert it to work for chrome instead of IE:
For Each htmlEle In ieObj.Document.getElementsByClassName("data data14902")(0).getElementsByTagName("...
0
votes
1
answer
403
views
get data from an existing open IE tab vba
my situation is as follows I have a website that users open that contains data that needs to be added to excel, I want to find a way that if I have an already opened IE tab the user will be able to ...
- 37
-2
votes
1
answer
411
views
Vba code to control Edge in IE Mode using iedriverserver.exe
Is there any code sample which I could refer ? To control Edge in IE Mode using iedriverserver.exe in vba. I have downloaded the exe but unable to add related library in tools->reference in vba ...
- 1
4
votes
1
answer
129
views
Will IE removal from Windows impact XMLHTTP60?
When IE gets removed from Windows, will this impact XMLHTTP60 and my Excel VBA code? How could one confirm?
- 3,480