website data

  1. K

    Macro to pull data from form website

    I have a spreadsheet containing Account number data corresponding to websites similar to: https://actweb.acttax.com/act_webdev/ellis/index.jsp I am trying to create a macro (or other technique) that will use the relevant account number from column A, enter into the website above, automate a...
  2. E

    Excel (VBA) to tries to pull data from a website but the page times out before it logs in

    Hello, I've just obtained this addon but it's not working in the sense that it won't log in to the website it was meant to. In the VBA the data goes like this: Sub logIntoCapsim(control As Object) Dim x As Integer Dim a As New agent a.visible = True a.openpage...
  3. C

    VBA/Macro Help - Pulling info from various websites that can be updated

    Hello, I am very new to VBA and macros. Currently I am taking a class on financial modeling at my university and we are required to build tons of models throughout the class. The teacher requires a few large assignments that requires us to basically reach out and take advantage of those who...
  4. M

    Populating ComboBox in pop-up window from external website

    First time poster. System / Version information: Microsoft Windows XP Professional 5.1.2600 Excel 2007 / Visual Basic 6.5. Background / synopsis: I am using Excel to open up an external website to generate reports. When it comes time to launch the report, a pop-up appears with combo boxes to...
  5. R

    Excel calculator form on web site

    I am a novice at building web sites but am trying to develop a work order form to be inserted on my website so customers can open a clear form, fill in the appropriate data, receive a price, save the document and email it back to me to place their order. So far I have created 2 workbooks and...
  6. M

    Transmit website data into excel

    https://www.theice.com/marketdata/reports/ReportCenter.shtml I need data of daily settlement of Cotton No.2 from above website to excel sheet i mentioned following page source code kindly help me thanks in advance. CATEGORY NAME is DAILY SETTLEMENTS option value="18" selected="true" MARKET...
  7. W

    Javascript / Ajax selection and click

    I'm still stuck trying to pass a website click from VBA. I think I've inlcuded the portion of the code below that is related to selecting the account. Any help on how I pass the proper variables through to ie and then "click"? function SelectAccount(id) { var params =...
  8. C

    Extracting stock prices into excel

    Hey guys I've been searching around for plugins and such to allow me to get automatic update on stock prices for my portfolio spreadsheet. The most popular one seems to be the MSN money stock quotes plugin but the link does not seem to be working, I've tried for days.... Is there any other...
  9. A

    Extract data from website directory

    Hi, I need to extract data from csv files from a website. The files are created daily and are listed on webpages split by category and then by year (i.e. /website address/category1/category2/filenamedate.csv) There is a login page for the website and I need to download the data from multiple...

Some videos you may like

This Week's Hot Topics

  • VBA (Userform)
    Hi All, I just would like to know why my code isn't working. Here is my VBA code: [CODE=vba]Private Sub OKButton_Click() Dim i As Integer...
  • List box that changes fill color
    Hello, I have gone through so many pages trying to figure this out. I have a 2020 calendar that depending on the day needs to have a certain...
  • Remove duplicates and retain one. Cross-linked cases
    Hi all I ran out of google keywords to use and still couldn't find a reference how to achieve the results of a single count. It would be great if...
  • VBA Copy and Paste With Duplicates
    Hello All, I'm in need of some input. My VBA skills are sub-par at best. I've assembled this code from basic research and it works but is...
  • Macro
    is it possible for a macro to run if the active cell value is different to the value above it
  • IF DATE and TIME
    I currently use this to check if date has passed but i also need to set a time on it too. Is it possible? [CODE=vba]=IF(B:B>TODAY(),"Not...
Top