yahoo

  1. R

    email area using Yahoo

    Hi guys, Hoping you can help me, I have a range of cells on a sheet A1:H32. I want to automate copying this area as a bitmap and sending to multiple recipients using my yahoo email. Does anyone have a bit of code for this please? Thanks Fletch
  2. S

    Yahoo Finance api change?

    I use the yahoo financial api to download mutual fund prices each day. It has worked fine for months. Today I got run time error 1004 application defined or object defined error the apparent cause of the error is highlighted in bold below. { code Set DataSheet = ActiveSheet...
  3. M

    run time error 1004 excel cannot access file

    I'm running a workbook which uses VBA. It uses the yahoo finance data lookup function and it usually works fine but its started to report this error: "run time error 1004 excel cannot access file" This is the line in the VBA that the debugger highlights when I run it...
  4. R

    Find and Replace Many

    Hello, I have an email database where it contains lot of Yahoo, Hotmail, Gmail and other email accounts in 1 column.. I want to filter and put the domain on the 2nd column. So for an example:- outlook.com, hotmail.com, live.com email accounts should be named as HOTMAIL in front. (2nd column)...
  5. C

    want to change the workbook link based on a text

    I have a workbook (Report) that is linked to another workbook (Yahoo Stock Quote) ... My (Yahoo Stock Quote) workbook has multiple tabs. I want to be able to link my workbook (Report) to Yahoo Stock Quote based on the tab I am on. For example =+'C:\Conrad\STOCKS\[Yahoo Stock Quote...
  6. M

    Stock Ticker Macro

    Hi all, I have seen a few threads over the past few months asking this same question, but haven't come across an answer so I thought I would ask here: I used to run a macro/function called StockQuote which was based off of Yahoo Finance's API that would allow me to pull in a stock's price...
  7. J

    Yahoo Search Button Click/Submit

    The following code works well to click a search button, so long as the element has an assigned tag name. Unfortunately I am not able to locate a name element for the Search button on the Yahoo home page. Can someone PLEASE advise on how to successfully re-write the code shown below to click...
  8. J

    Uploading Yahoo Spreadsheet & Calculating Returns

    Hello, I'm a novice with Excel, need to calculate returns (quarterly and monthly) using spreadsheet from Yahoo, but can't figure out how to make it so that the returns are automatically calculated using the information from yahoo. Can this be done on excel? Thank You.
  9. M

    Excel yahoo finance VBA run-time error

    I use this code to retrieve historical stock prices for about 40 tickers. I found it here http://www.mathfinance.cn/download-multiple-stock-quotes-from-yahoo-finance It downloads about half of the symbols before a Run-time Error '1004' pops up. "Unable to open...
  10. J

    Querytables in Loop

    Hi, everyone. I want to download a list of the components of a stock Index from Yahoo! Finance (i.e.: http://finance.yahoo.com/q/cp?s=%5EIXIC+Components). In order to get the list in a .csv file, it is possible to get a web address, but it's limited to 50 records (i.e...
  11. R

    Automatic category selection as seen in Yahoo Answers

    Hi, I have a list of keywords with related category of incidents they belong to. I would like to create an automatic category selection in Excel based on the keywords entered by a user. For instance, if a user enters "SAP password reset" I want to match those three words...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top