internet

I have a macro which fetches data from particular website. I want to check howmuch data is consumed while this macro is running? can someone help me?

I'd like to import graphs from webpages to Excel. E.g. many webpages show intraday stock prices and I'd like to include some in a "dashboard" style worksheet that can be up-dated. Is this possible with Excel?

Hey guys, I've looked at a few forum posts on here but have yet to come to a definite solution for my problem. In short, I am trying to import the table on the following link: Fantasy Basketball Projections It is a table of numberfire's projection for NBA players each day. However, the table...

Hi Guys. I'm doing some web automation using the script below: strURL = Activecell.value 'this is the url to test Set objhttp = CreateObject("MSXML2.XMLHTTP") objhttp.Open "HEAD", strUrl, False objhttp.send If...

Hi Guys. I'm using the following code to work out if a link to a url is broken or not: strURL = Activecell.value 'this is the url to test Set objhttp = CreateObject("MSXML2.XMLHTTP") objhttp.Open "HEAD", strUrl, False objhttp.send...

I want the macro to navigate to: Tesouro Direto - Consulta Ttulos and retrieve the second "Compra" row value of the: NTNB Principal 150824 NTNB Principal 150535 LTN 010118 For example, for a instance, it should get: R$ 1.386,49; R$ 713,74; R$ 692,93. Notice that those prices change...

Guys, i've been trying this for a long time and now i give up trying lol. i want a macro that access the website https://br.financas.yahoo.com/q?s=pmam3&ql=1 copy the value of the quote, then paste at the worksheet after that, go to the "digite o símbolo" box, search for another quote and...

Hi there ! I would like to download a file from a website using VBA. The tricky part is that the file is generated after filling a form in the webpage and clicking on the submit button, so I don't know its name and address before download (meaning I can't use the URLDownloadToFile API)...

Hi, I'm using the url extension for Google's "I'm feeling lucky" functionality but want to copy the url this function opens (i.e. the direct url). I'm using the below macro which works fine but need it to loop down a list until it finds a blank cell. I have a list of hyperlinks in column E...

I am curious if anyone has collected any resources (or knows where I can find them) that detail how VBA searches and parses the web. I have read posts, visited microsoft's development resource center and read articles on how specific tasks may be accomplished using internet controls and...

Hi All, Thanks in advance for your help. My question is pretty much summed up in the title. I have a .csv file that is saved in the same location as the same name every day. I then visit a webpage that has some text, a field for the file name/path, a browse button, and an upload button. I...

I have a Google Analytics Macro that works perfectly fine in Windows, but I need to use it in MAC. I am having trouble opening a browser and navigating in it, including this code here: Set HTMLDoc = oIExplorer.document HTMLDoc.all.Email.Value = GAlogin ‘this is a string I got in another...

Hello! I have an excel file that has numerous download links (example below) in a column. Is there a way to 1. Open the link on an internet browser 2. Accept the download and then 3. Open the downloaded file? www.123contactform.com/upload_dld.php?fileid=0b5af5ff707e692b158427473985056e The...

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

Hi, I've been looking on an answer of how to do this, and most of what I've found regards what I CAN'T do, vice what I CAN. Problem: I have multiple users that need to edit an excel file simultaneously, I'm want to maintain one copy instead of sending everyone an email with the document to...

Hello All, First, thank you for view my question. I am trying to link data from a website to excel, and have it automatically update, but it doesn't seem to be working. I have excel 2007. 1. I go to the "data tab", 2. click "from web", 3. paste the website I am trying to get data from...

:confused: I would like some help to create a code to check for internet connection. I have a macro that emails automatically using gmail if there is an internet connection. As soon as there is no connection, I get an error. I need some help with some code within the macro to check for...

http://www.mrexcel.com/tip103.shtml Hi all! With regards to the link above, which explains how to download data from the internet to an excel file, I had a further question. Is it possible to download data from the internet at set intervals, but instead of overwriting the previous data (which...

My spreadsheet has films and related info, laid out in standard columnar layout - one row per film, data (director, year, etc.) in columns. I would like to populate the "Blurb" column with info from an external web site, e.g. the storyline section on IMDb. Is there any way of running a query...

I need help trying to retrieve the source code from a website. How I normally navigate there: I start at http://www.bls.gov/home.htm, scroll over Subject Areas, click Consumer Price Index, click Top Picks button for All Urban Consumers database (probably have to scroll down a little), check...