data scraping

Hello, I am trying to pull current market data (bond rates) into excel from the below link: https://rates.chathamfinancial.com/us-market/rates In short, I am trying to pull the rates for each respective term in the 'Current' column as per the highlighted below. I have been able to do this...

Hi All, I simply do not have the skill set to solve a problem I have. I am creating a database for my students of compounds in chemistry. I have an excel list of the compound names. I have also created a url link (using the concatenated function) that enables me to go to google and there I can...

I wrote a code to pull a table from a website. The website has a calendar feature and part of the web address can be edited to pull the correct table based on the preferred date. I tried to create a macro that deletes the current table, copies a cell for a new date, opens the code and pastes the...

Respected Mentors, Please help , I have a excel VBA code that find the website URL's from the Name's of company'es but i also want to import email address as well from names or from website URLs from google or map. Many Thanks

Sub Scrambledata() Dim ie As Object, objInputs As Object Set ie = CreateObject("InternetExplorer.Application") ie.Visible = True ie.Navigate "http://www.scramble.nl/military-database/usaf" Do While ie.ReadyState <> 4: DoEvents: Loop...

I want to create a spreadsheet that will send a product link to amazon.com and have amazon send back certain product information to excel For example, here is a product link that would reside in the excel spreadsheet: Amazon.com: Corelle Livingware 16 piece Dinnerware Set, Service for 4...

Program: EXCEL 2010 OS: Windows 8.1 I am wanting to login to a site (I have a login script), navigate to a page, then download the `.CSV` file that will always end with a dynamic string due to it being 'custom'. I have tried to access the site by recording a macro. However, as the...

I need to be able to automate data scraping of property assessment data for work, and I keep getting Error 70: Permission Denied. The weird thing is that for testing purposes, I left IE visible and the page navigates correctly, but the debug error stops a process that seems to be working. I...

I am trying to create a macro that pulls (and will update) property auction data from auction.com. I am new to data scraping using vba and for each auction, I need to pull the Property Address (and maintain the hyperlink to the href address in Excel, ideally), Item #, Starting Bid, and auction...

Hello :) I'm a total VBA newbie, but need to create a data scraping tool. I've managed to find something on YouTube that showed me how to do the majority of what I want, but it doesn't seem to be working. This is what I have so far: Sub ie_open() Dim iRet As Integer Dim strPrompt...

There is a government website (http://www.mca.gov.in/) where there are details of every Indian public company. I want some data to automatically load in my excel sheet. Problem is that for every query sent to this site, a new window opens. I want to get the 'master data' but unable to write a...