data mining

Hi, I am newbie please help I need to extract addresses by entering lat and long on below mention website and need to extract data on text box on which it appears. but it is giving error of object variable or with block variable not set Please also tell me how get data from text box thanks...

I'm using an import function to have a real-time daily production compared to our needed output for our accounts. However, the website where the numbers are recorded is password protected so when the function tries to import the data it can't get past the login page. The url is...

Hey Mr. Excelers, I work at a bank. Very often I need to find a variance (specified value) out of a large range of numbers. Say for example I have a bunch of transactions: <colgroup><col></colgroup><tbody> 110.00 250.00 156,875.00 2.00 5,566.27 69.80 15,000.00 189,987.00...

Hello, I'd like to understand how to extract specific rows from a (Standardized format) word file into an Excel spreadsheet. Here's the Word file I've uploaded to Box... https://app.box.com/s/s262fcw0nv4jz8bjyij9ik8dzsqmpive ... however in case someone doesn't want to download the file for...

Hi, I am new in here and I would really like to find out if there would be interest from the community for our latest Excel Addin that uses an implementation of Decision Trees for time series forecasting.This is a tested algorithm that has been developed over a number of years and used...

SUMIFS ignores errors and just returns 0, how to return N/A ? IFERROR won't work, countif also didn't help. IF 0 then N/A - not applicable, as I also have some actual zeros, that I need. <tbody> City Country Provider Sum A XY Apples 200 A XZ Apples 100 </tbody> Table where I look for...

Hi All, This may seem ambititious but I have done it before (about 13 years ago) so I'm sure the functions are still there. I have multiple sheets in a workbook with the same name and an ascending number (e.g., "data 1" , "data 2", etc..) and I want to compile the information from specifics...

<div id="resultStats">About 2,660,000,000 results<nobr> (0.20 seconds) </nobr></div> This is coming from the source of Google's home page (right under the search toolbar). I essentially want to pull down the phrase "About 2,660,000,000 results". Up to this point I have been using Excel's web...

I have a spreadsheet the runs Columns A - AF and Rows 2 - 1529 and increasing. In Column B I have the project numbers which are currently in use. Sometimes when I sort by other columns, for instance Column M contains the Part Number, when I sort by the part number the result will return...