Well, at least you are sorted now.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"
wrote in message ...
Bob

I thought I had already closed and added the Add-ins but I somehow screwed
it up. Problem fixed. Sorry for being a arsey on the last email - long
day!

Cheers

James

"Bob Phillips" wrote:



"
wrote in message
...

I think that when you open a new instance of Excel from another MS App
the
Addins do not get loaded.

That ius exactly waht I said, which is why I suggested forcing the load.
I
was able to reproduce your error, not from MSProject but from
automation,
and by installing the addin, it worked fine.

In this case I am using MS Project to load Excel.
I have just noticed that when I type in MyApp.worksheetfunction then
press
the '.' button for a list of methods/property parameters (?) it
doesn't
list
networkdays.

Networkdays is not a worksheetfunction, it is part of the Analysis
Toolpak,
so you won't see it, even from within excl