html

I work in copywriting and one of the columns in the lay outs we do require HTML code (for the products we upload to our webpage), but if I copy an entire column to an HTML converter it will obviously turn the table to HTML too. Is there a way or a webpage that can change ONLY the text within the...

<div class="row"> <div class="col-xs-12 form-group"> <input type="submit" name="btnSearch" value="Search" id="btnSearch" class="btn btn-primary" /> </div> </div>...

Hi all! I'm trying to pull weather for certain locations. I've got the scraping part down. I'm having trouble controlling the location; results are intermittent if I use a hard coded URL or if using cells in the worksheet to complete the URL. Sometimes it if trying for Seattle, WA it ends up...

I have been trying to use VBA to webscrape some data, however, i have not much success being able to click on the hyperlink or call the onclick function. Help will be very much appreciated. My code is listed below as well the only HTML information is listed as below <tr class="linkable"...

I have a bunch of data that was exported in an html/xml format. <schoolFood1Type location="" size="0">63</schoolFood1Type> <schoolFood1Order location="" size="0">198</schoolFood1Order> <schoolFood1ProgramA location="" size="0">Yes</schoolFood1ProgramA>...

Hello, am trying to convert an excel file to HTML. I have a few 100s of rows. Serial No. Name Composition 1 Destadine Syrup Each ml contains: Desratadine BP …….. 0.5 mg In a flavoured syrup base 2 Chlorphamine Each ml contains: Frech BP …….. 0.5 mg In a flavoured syrup base...

Hi There, I'm having a lot of trouble trying to get a simple webscrape to work. I am using a dynamic URL to search for a product (in this case 'GREENE KING ABBOT ALE') and what I'd like to do is have all the available links that return from the site to appear in column A of sheet called 'Single'...

hi dears i have excel with 10 sheets and i need vba for convert to 1-html format and 2-csv comma utf8 and 3.txt format 1-do it for entire workbook automatically and with no question 2-for each sheet make seperate file name and same as sheet name in my excel file path 3- printarea by default...

I am scraping HTML tables with a GET request. The req.responseText is then passed to the module below to process the HTML tables. My code works 100% but I'm trying to optimise it. It is a large daily crawl. I have 2 questions: 1. In the section where I'm processing the "className =...

Hello, I'm looking to import a few images into my excel file and I plan on importing the picture by calling the pictures based on their html elements. The image html code: <img chart-id="2669" alt="Chart ID 2669" class="chart-img" src="https://website.com/569134694870.jpg"...

Hi I have the following macro which exports my sheet (Page1) as an HMTL file and it works well, except it exports the entire page. I was wondering if it could be modified to export only a selection of cells on the page? such as A1:CN106? Sub HTML_File() With...

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...

Hi I am new to this, i watched a few tutorials and tried out on my own and realize that i can't even do a search in the search box of the webpage. Below is my code that i tried. Sub Automate_IE_Load_Page() 'This will load a webpage in IE Dim i As Long Dim URL As String Dim IE As...

Hello, I'm having a hard time getting my vba code to work. What my code is doing is opening a website, entering the username and password and then I want it to click the login button. My current problem however is that I cannot get my code's loop to Click the Login button once my username and...

Dear All, I have an html code available in an excel column (Please refer below table). My aim is to send that code to Word Document using mail merge and convert the code in to a Table when it is merged in word document. However when excel column in merged in Word Document the html code is not...

Trying my hand at web-scraping again. I want to grab a specific text from a website, and to do so the first part of my code dumps the website's response into a cell of the worksheet. Here is the code: Sub Test() Dim URL As String Dim HTTPObject, HTMLObject As Object URL =...

Hi all, i will load data from a html website. the problem is i can not use "CreateObject("InternetExplorer.Application")" because the site don't load in the internet explorer. In Firefox the side works. i need all data in the blue boxes from all 4 Areas i test it with...

looking to download a PDF from a URL. I can't seem to get past the login screen as the pdf that is downloaded only contains the code for the login page if I open it in NotePad. I examined the post request after logging in manually and pasted it after "FormData." I'm not sure if it matters what I...

How do I select an option from a dropdown menu and update the webpage. Code: Dim IE As New SHDocVw.InternetExplorer Dim HTMLDoc As MSHTML.IHTMLDocument then I navigate to a URL and I fetch the dropdown menu using html id and put value=my desired value HTMLDoc.getElementById("xyz").Value =...

Hello! I'm struggling with a task that is above my knowledge. I have a huge table like this example below: id html code model model model model model model 1.10.M1007 <tr><td>Asus M6 Serie</td><td>Asus M6000</td><td>Asus M6000 Serie</td></tr><tr><td>Asus M6000A</td><td>Asus...