Skip to content Skip to sidebar Skip to footer
Showing posts with the label Vba

Scraping A Value Of A Website Using Vba Where The Classname Is Duplicated

Ok This question has a 2 parts to it. I need to scrape the value R1200 from the website into Excel… Read more Scraping A Value Of A Website Using Vba Where The Classname Is Duplicated

Vba Code To Click On Excel Icon From A Webpage - Part 2

Following on the post Click on Excel Icon to download data Part1 There is another Excel icon to dow… Read more Vba Code To Click On Excel Icon From A Webpage - Part 2

Sending Email From Lotus Notes Using Excel And Having Attachment & Html Body

Right I'm trying to send an Email form an excel spreadsheet though lotus notes, it has an attac… Read more Sending Email From Lotus Notes Using Excel And Having Attachment & Html Body

Manipulate Ie With Vba And A Modal Form

I'm trying to automate the uploading of an excel document to a particular webpage. I can't … Read more Manipulate Ie With Vba And A Modal Form

Alternating Colors Of Rows With Html

I am currently writing code in VBA to automate a process that sends out an e-mail that contains a t… Read more Alternating Colors Of Rows With Html

Press A Button On A Webpage Using Vba And Without Opening Ie

I was wondering if it is possible to 'click a button' on a webpage without opening the page… Read more Press A Button On A Webpage Using Vba And Without Opening Ie

Vba Code To Copy Table From Webpage Into Excel

I have modified the code to try to get a sequence of similar tables. However, these tables copied i… Read more Vba Code To Copy Table From Webpage Into Excel

Vba Getelementbyid Doesn't Work For Button

I am trying to go on a website, type a value in a textbox and then click the searchbutton to search… Read more Vba Getelementbyid Doesn't Work For Button

Parsing Html To Recreate Tables In A Word Document Using Vba

Is there a way of taking html code for a table and printing out the same table in a word document u… Read more Parsing Html To Recreate Tables In A Word Document Using Vba

How To Access Innertext Of Html Tag Inside A Tag

I would like to get some text from a web page containing this. I want to have the piece of informat… Read more How To Access Innertext Of Html Tag Inside A Tag

(excel Vba): Accessing Json File - Operation Timed Out

I'm attempting to pull data from a JSON file on the web. I'm using a dummy JSON file for th… Read more (excel Vba): Accessing Json File - Operation Timed Out

Mshtml: Createdocumentfromstring Instead Of Createdocumentfromurl

I'd like to use the MSHTML library to parse some HTML that I have in a string variable. Howeve… Read more Mshtml: Createdocumentfromstring Instead Of Createdocumentfromurl

Get The Value Inside Nested Tables And Divs Using Vba

I have tried multiple solutions posted around and yet to get the code working. I would like to copy… Read more Get The Value Inside Nested Tables And Divs Using Vba

Loop Through Div Elements Using Vba

I'm having an issue with looping through div elements, well I dont know how to do it. The code … Read more Loop Through Div Elements Using Vba

Write And Save Html In Excel With Vba

looking for help as I have not found anything on this specific topic yet. Goal: I would like to wri… Read more Write And Save Html In Excel With Vba

Excel Vba: Get Content From Online Html Table

can anybody pleas show me part of VBA code, which will get text 'hello' from this example o… Read more Excel Vba: Get Content From Online Html Table

Modifying The Program For Parsing

There is a program that parse a certain table from the site . Works great . I want to parse another… Read more Modifying The Program For Parsing

Webscrape Vba With If Condition

I am trying to import the bullet point from a website into an excel table (each bulletpoint filling… Read more Webscrape Vba With If Condition

Replace Html Tag(
) With Alt+enter In Excel

I am working on VBA, but I have one problem of how to replace a tag of HTML with Alt+Enter. For exa… Read more Replace Html Tag(
) With Alt+enter In Excel

Input Text Into Html Input Box Using Vba

I am trying to input a value into a from on an internet explorer page using VBA. I have seen simil… Read more Input Text Into Html Input Box Using Vba