web automation

Hey folks, I'm hoping someone can help me out with a VBA code. I need something that will open the website Heavy Duty Truck Parts Online, Medium Duty, Light Duty - FinditParts, search for the PartNo located in Column A, on the website, and provide the results in Column B. The result should be...

Hi All I was hoping for any assistance with VBA code which can return VAT registration details from HMRC's website. If you click on the link https://api.service.hmrc.gov.uk/organisations/vat/check-vat-number/lookup/362012792 then you get a valid response as per the attached. By changing the...

It is possible to take website snapshots quickly and easily with any chromium-based browser (this includes Chrome (obviously), MS Edge, Brave, and Opera) as they all include headless browser functionality - this means that you are able to use VBA give your browser instructions to generate...

I am trying to submit one form in webpage using vba excel as inputs. I can see text appearing on each form fields but gets dissappear when I click on submit button. When I manually click on each field, the size of field gets extended and text won't dissappear. Can anyone please help why it is...

Dear all, I am trying to input text into a webpage and search and am running into problems. Below is my code Sub GetHTMLDocument() Dim IE As New SHDocVw.InternetExplorer Dim HTMLDoc As MSHTML.HTMLDocument Dim HTMLInput As MSHTML.IHTMLElement IE.Visible = True...

Hello guys, i am working on project where i need vba code to click on "Add Filter", code here looks like - <div class="select-filter-field no-filters" ng-class="{'no-filters' : currentOptions.length === 0}" ng-click="addFilter()"> <i class="fa fa-fw fa-filter"></i> Add filter...

Hello, remembers of the forum I'm having troubles with webpage scrapping by using VBA I know I can select element of page by using - getElementByID - getElementsByClassName - getElementsByTagName However, I have no idea how to get data by Attribute For example...

Hi all, I've been trying to extract data on some website inside Internet Explorer. I've been able to do it right with this code on some of the websites that I need to work on. But now i just encountered a problem on this specific website in which I cant extract the data that i need because my...

I am looking to get a web form filled with excel data wherein VBA opens the URL from the list and then fill the data as per the excel cells data (B2, C2, D2...) Refereed some online data and tried to get the code of the web page which might help you in getting a solution <form name="CREATE"...

<!--[if gte mso 9]><xml> <w:WordDocument> <w:View>Normal</w:View> <w:Zoom>0</w:Zoom> <w:TrackMoves/> <w:TrackFormatting/> <w:PunctuationKerning/> <w:ValidateAgainstSchemas/> <w:SaveIfXMLInvalid>false</w:SaveIfXMLInvalid> <w:IgnoreMixedContent>false</w:IgnoreMixedContent>...

I'm trying to automatically click a radio button on a webpage. Here's the relevant HTML code: RW B I want to click the radio button in the second TD. I can't use the element ID because I intend to use the same macro on other webpages of the same type where the ID and value differ but the...

Hello everyone, I've referred to MrExcel countless times over the years to learn Excel and VBA, so firstly thanks to everyone who contributes to make this such an excellent resource. I've now encountered an error which I'm not able to find a solution for. I've been using this code for months...

Hello, I am currently running into a problem when trying inputting code into a web form. The code I have works fine for entering in the information but I am getting an error from the system stating that the entry is invalid even though its correct. If I copy and past into this field the...

Hello All, I am having trouble being able to capture what I need from an HTML website to extract data for my VBA code. My code automatically uses a webpage to search the distance between two airports. That part works fine, extracting the actual value of the distance is giving me problems. The...

I have created a workbook where searching a customer name give you the respective details needed. Below is the sheet 1 where you get the data. Sheet 2 has be actual database. I want this as a web portal. How to create it .Please suggest. <tbody> SEARCH BY CUSTOMER NAME SEARCH ----- >>>>...

Can someone please help. I have been looking for a way to pull information from zillow and haven't found much. I would like a macro to pull all the normal stuff like zestimate, number of beds, baths, sqft, and price of a property as well as surrounding properties that are and are not listed. but...

Hi Friends, I am working on an web automation where I have to provide input to a webpage in which a different control I saw named as range input this is the website . Once user change range by dragging mouse one chart get updated. Set oTab1 = IE.Document.GetElementById("credit-score") Set...

i found vba code that automatically opens a new session of IE explorer, navigates to a specific website and then logs in. it only seems to work when i test it in the vba editor. it is currently assigend to a shape however it doesnt keep the IE session active and ends up pasting the login...

Hi All, I need to download a file from the web in CSV, the problem is that when the code click the bottom the file save window prevent the code from reaching the next line. I check similar topic on this forum (see...