html

Afternoon, I am trying to automate some IE navigation. I am running into an issue when trying to populate a field. The object will allow for text entry - but i cannot seem to find a way to fire/trigger an event to populate the dropdown list that will then allow me to select from their...

I am going nuts trying to figure this out! I am needing to navigate to a site and login through VBA to scrap some data. (which I have done several times before) I cannot for the life of me figure out the HTML for this particular site...

Hello, Is there a way to keep the assigned ID with each customer ? I want to be able to sort the table but when doing so the ID numbers for the customers change. Thank you very much Excel WorkbookABCDEFGHIJ1IDContact NameCompany NameStreet AddressCitySTZip CodePhoneEmailNotes2101JohnBank12...

Hi, I have been attempting to automate a web scraping process and I am needing to click a button on the web page; however, my object is constantly empty. Here is the html code: <div class="pull-right"> <button class="btn btn-primary js-export-customer"><span...

Hi, In order to automate a site and get around using the date picker ive found I can remove the 'read only' part of the input on the site which allows me to input the date, however i cant seem to automate this. Im trying to change : <input id="fromDatePicker" placeholder=""...

I have been looking around the internet with no success for a VBA function which will simply take 3 arguments: Currency From, Currency To, Date and output the relevant FX Rate. Has anyone worked with a successful solution? I am currently using this procedure which works fast but it outputs a...

I’m trying to select a value on the html dropdown box with excel vba code (as far as I know the html is javascript) but I’m not good at html. I have tried every possible proposal from various forums, without luck. The web page is an internal company page, so unfortunately it cannot be shared...

Is there an updated version of the HTML Maker addin for current versions of Excel such as Excel 2019 x64? All of the addins I used to use seem to no longer work. I don't know if its the version of Excel being newer or if its 64 bit. The one addin I was able to get working, ASAP Utilities, did...

Hey Guys, I'm wonderng if it is possible to transfer data from exel vba to multipe HTML Input boxes? I would like to replicate the HTML Form onto an Excel UserForm which will be used to automatically generate data. I woud then like to have a button_click on the userform to transfer the UserForm...

I need to get some data from html, but my code does not work for the first set of data the Tag = a Id = u_0_p and for the second it is via class Tag = div Class = _50f4 I was doing this but it does not work dd = doc.getElementsByTagName("a") .getElementById("u_0_p") '(0) .innerText dd1 =...

Hi all, will need some help on using excel vba to extract a specific row and column of a html table. I m actually trying to check on a values base on a specific row n column, if the value if true then it will click on the button at the end of the row. Please do explain on the codes as I do not...

I cant seem to work out how to input text into the text field, when inspecting the element in google it gives me: <input> class="gwt-Textbox" type="text" size="35"> current code im using is: im htmldoc As HTMLDocument Dim IE As InternetExplorer Dim myhtml_element As IHTMLElement Dim...

Sub BETWEF() Sheets("BetEX").Select Dim httpReq As WinHttp.WinHttpRequest Dim HTMLdoc As HTMLDocument Dim para As HTMLParaElement Dim tRows As IHTMLElementCollection Dim tRow As HTMLTableRow Dim URLs As Range, URL As Range Dim destSheet As Worksheet...

Hi Everyone I have an HTML file that resides on a local drive(C:\Users\HOME\Dropbox\DAILY_SALES_REPORTS\DAY_END.HTML) but opens in a web browser. All I need is to copy the entire main body of the HTML and insert or paste to a particular worksheet(IMPORT_HTML) with a macro. Been all over the...

Hi Everyone, I am looking for ideas getting an HTML document into Excel. I've tried the standard "Get Data" but I end up with a 4MB file and have 30-35 tables daily. If its possible to import the entire HTML document to one worksheet with a one click solution that would be great. Any...

I have downloaded the add-in, extracted the add-in to the Add-ins folder, UnBlocked it and installed it in Excel. I have a menu option called "MrExcel HTML Maker". On that ribbon is one group called "Generate HTML (Specify Options)". The options listed are: All Formulas First Cell Only First...

Hi Excel Guru's, I am having trouble with html borders when the email is read via gMail (Outlook/Apple Mail Client both read it). I googled and there wasn't much info, other than someone suggesting I change the .BodyFormat = 2 (or 'olFormatHTML)...which didn't work :( Please help me figure this...

What is happening when I try to type WP(R) in to a cell and how do I stop this please? Excel WorkbookA1WPSheet1

Hi All, I am getting a error as "Error: Resource at url contents exceeded maximum size." when i am trying to extract data from HTML page. Please help me extract the data in google sheet. PS: the data contains 45000 line items.

Hi, I am new in VBA. I'd like to create a VBA script to select the value "associate" from a html dropdown list. Could you help me with writing this script? Here is the html code in the website <h2>Return To Station</h2> <div id="searchUserInputContainer"> <div...