| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Yield VBA function missing in Excel 2007
Price and Yield are now part of standard functions in Excel-2007.
Application.WorksheetFunctions.Yield(7 pars) returns error: "Object does not support method", when called from VBA code. I believe it shouldn't. It works fine in the cell (=YIELD(...) ). All others functions used (Price, Duration, MDudation) works fine from VBA. I'm using Office-Pro-2007 60 days Trial, with SP1 included, Activated; to update a 2000 and 2003 project for Office 2007 use. Is this a bug? Is beacuse of Trial version? Some SP missing? Thanks for any help. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Current Yield vs. Yield to Maturity at low prices | Excel Worksheet Functions | |||
| Error when using Yield in Excel 2007 VBA | Excel Worksheet Functions | |||
| Yield() function missing from XL2007 SP1 ATPVBAEN Analysis ToolPak | Excel Worksheet Functions | |||
| MS Query (Excel 2007) - OLAP-Function is missing | Setting up and Configuration of Excel | |||
| In Excel, can a function yield a drop-down list? | Excel Worksheet Functions | |||
![Michel Petit[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
