internet

  1. S

    VBA macro to check data cosumption while running

    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?
  2. J

    Importing a graph from the internet to Excel

    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?
  3. S

    Having trouble mporting data from a website

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

    Set timeout on MSXML2.XMLHTTP .send method

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

    Getting redirect destination from an xml .send url action

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

    URGENT - taking data from the web

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

    VBA extracting data from web

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

    VBA - Can't get to download a file

    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)...
  9. S

    Looping issue: List of Hyperlinks and Copying from IE to Excel

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

    Using VBA to search the web and extract elements

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

    VBA open Internet Explorer, go to site, upload .csv file

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

    VBA for MAC navigating in internet

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

    [VBA] Downloading and Opening a file

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

    Internet data scraping

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

    Multiple users editing documents simulatneously over the internet

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

    Linking Excel with website

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

    VBA code to check for Internet Connection

    :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...
  18. L

    downloading data from the internet

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

    Get blurb from web site (IMDb) into Excel

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

    Data Extraction from Website

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

Some videos you may like

This Week's Hot Topics

  • Copy entire row if CountA <>0 to another sheet
    [B]I want to copy entire row if CountA <>0 for column J7:AM7 (headers on J6:AM6) and so on till the last used cell is column D and paste the...
  • Select last used Row in Table
    I have created a Table in a Worksheet which is locked to prevent user errors and protect formula. Some of the cells require freetext entries which...
  • excel workbook: do not allow certain file name
    Hello all, Don't think this has ever been asked before, but how do I restrict file save [Before_Save Event] if the name of the file being saved...
  • fixing problem autofilter
    hello i need help about my code when i search by code in textbox it doesn't show anything this is my data [ATTACH type="full"...
  • “Weight”
    Hi, i’ve got a long sheet filled with weights such as kg,g,L & ml. i can build a formula to convert kg into g and liter into ml. How ever, my...
  • How to capitalize everything before a certain character?
    In column A, I have some text: Hello good day.mp3 Hello good day.flac etc. I'd like to capitalize everything before the period. I don't need the...
Top