Hi James,

And after you've sorted that out, check the cell references in your formula in the worksheet; it IS A6 and B6 (Columns -3 and -2,
not Rows)

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Bob Phillips" wrote in message ...
| James,
|
| When you use Excel via automation, the addins do not get loaded, so you get
| the error.
|
| Force the load like so
|
|
| xlApp.AddIns("Analysis ToolPak").Installed = False
| xlApp.AddIns("Analysis ToolPak").Installed = True
| xlApp.Range("D6").Value = "=networkdays(rc[-3],rc[-2])"
|
| --
| HTH
|
| Bob Phillips
|
| (replace somewhere in email address with gmail if mailing direct)
|
| "
| wrote in message ...
| it is D4 and D5. More importantly the function name is not in capitals
| implying that XL can't see the function name. The Analysis toolpak has
| been
| ticked in the Add-ins
|
| Try it creating a simple macro in Word - I can give you the code if you
| want
|
|
| "Niek Otten" wrote:
|
| Be aware that your formula is not referring to D4 and D5, but to A6 and
| B6. Are any of them #NAME?
| I assume that you have Analysis Toolpak ticked in your worksheet Add-ins
| menu, not (just) VBA
|
| --
| Kind regards,
|
| Niek Otten
| Microsoft MVP - Excel
|
| "
| wrote in message
| ...
| | Sorry Niek doesn't work. In my experience .value and .formular1c1
| work the
| | same
| |
| | James
| |
| | " wrote:
| |
| | I am using VBA in MS project to enter information into Excel 2003.
| It
| | creates an instance and enters various dates. However if I put the
| | Newworkdays function into a cell (e.g. xlApp.range("D6").value =
| | "=networkdays(rc[-3],rc[-2])" where D4 and D5 are recognised dates I
| get the
| | #NAME? error message. The Add-ins for the Analysis toolpak have
| been ticked.
| |
| |
| | I tried running code to turn the analysis toolpak off and then on
| | programatically but still the same error message
| |
| | Any ideas how this can be fixed?
| |
| | Many thanks
| |
| | James
|
|
|
|
|