web page

  1. E

    VBA code to use a web query with the option to insert user name and password

    Hi I want to use the method of web query (Data-From web) and to get a vba code that can insert the user name + password to a url login page. I try but its not work for me. Need your help :) TNX
  2. J

    Scrap the details of website

    Hi, I'm trying to extract some data from www.ebay.in website, wherein, when the category is selected, the name, price and URL of all the products on first page extracts in an excel sheet. I tried doing that, but getting a Debug error on setting HTML Document. Sub ebayprj()Dim ie As...
  3. L

    VBA - Scraping a Web Page Problem

    Hey, I'm trying to obtain the id's of rows in a table on a website (the url is in the code). My problem is that I can't find the table. When I run the code it tells me that only one table exist, and that is not the one I'am looking for. Can someone please explain to me why it only returns the...
  4. P

    Question Import data from web page

    Greeting's, I want to wish everyone a very happy new year. Hope everyone has a good one! I want to import NAV (Net asset value) of Mutual funds to a cell. I want to do this to know current network by multiplying NAV with number of units. I have three webpages to pull the data from: (Following...
  5. U

    Web page in excel

    Is it possible to pull data from an interactive map on a webpage into excel? this is the website: UK Sustainable Drainage Id like an excel sheet to have a form with the websites map on it. Then the user can select their location on the map and it will produce the "m5-60" and ""r" Ratio" Map...
  6. S

    How Can I stop Excel from Crashing When downloading a page from the Internet?

    I am using excel and VBA to download a number of web pages and parse data from those webpages. I have my code set up but on occasion (every several hundred pages) the application crashes because it can't get a response from the internet. My question is can I add code that essentially instructs...
  7. M

    Pop up html page

    Hello everyone, I am working on a website automation and I'm facing a real problem there. The web-site is Consumer Prices (MEI) : Consumer prices - Annual inflation and I am able to navigate the page. There is a drop down which has options of downloading the data from the site in various...
  8. D

    saving excel workbook as web file

    hi everybody, im getting my head around excel and ive managed to create a fully working dashboard for my company, however, i am now requested to put this "dash" on the local intranet. i have saved it as a web file, but when i open the web version, most images and buttons have moved to the right...
  9. C

    Copy PDF from web page to Excel

    I seem to be missing something obvious with this issue and i cant find a suitable answer anywhere so I thought that i would ask the experts. I have a number of macros which i use to open up a web page in IE, copy the data and then paste it into excel. however i have a problem which i cant...
  10. P

    VBA clicking on websearch Result

    I am trying to get property tax values for about 200 properties. The info is publicly available on this site: http://www.hawaiipropertytax.com/Searc/GenericSearch.aspx?mode=PARID I have a list of Parcel IDs (also known as TMK Value) that identify properties in a spreadsheet. Here are just two...
  11. R

    VBA programming help

    I want to click on the "Download Spreadsheet" link in the following web page using Visual Basic. I've already opened Internet Explorer and signed in with an Excel macro. The web page is at: http://finance.yahoo.com/p?k=pf_1 Sign in: mistertester2 Password: M8R-hlylld Please help, even if...
  12. R

    Clicking a web page button with an Excel macro

    I can get to the following web page:http://finance.yahoo.com/p?k=pf_1. (Sign on:mistertester2, Password:M8R-hlylld) from an Excel macro, but how do I code the macro to click on the "download spreadsheet" button?

Some videos you may like

This Week's Hot Topics

  • Timer in VBA - Stop, Start, Pause and Reset
    [CODE=vba][/CODE] Option Explicit Dim CmdStop As Boolean Dim Paused As Boolean Dim Start Dim TimerValue As Date Dim pausedTime As Date Sub...
  • how to updates multiple rows in muliselect listbox
    Hello everyone. I need help with below code. code is only chaning 1st row in mulitiselect list box. i know issue with code...
  • Delete Row from Table
    I am trying to delete a row from a table using VBA using a named range to find what I need to delete. My Range is finding the right cell. In the...
  • Assigning to a variable
    I have a for each block where I want to assign the value in column 5 of the found row to the variable Serv. [CODE=vba] For Each ws In...
  • Way to verify information
    Hi All, I don't know what to call this formula, and therefore can't search. I have a spreadsheet with information I want to reference...
  • Active Cell Address – Inactive Sheet
    How to use VBA to get the cell address of the active cell in an inactive worksheet and then place that cell address in a location on the current...
Top