Set a reference to the Analysi Toolpak, atvbaen.xls, in the VBIDE.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Dave" wrote in message
...
Hi,

I am trying to use the networkdays function to open a previous day's file.
I
am receiving an error that the function is not defined. Why do I need to
define this Microsoft function? Any suggestions on how to open a previous
day's file that is saved as FileJul3108 excluding the day before if it was
a
weekend day or holiday?

PrevSuffix = Format((NETWORKDAYS((DateAdd("d", -1, Date)), ,
HolidayList)),
"Mmmddyy")

HolidayList = Array("Sep0108", "Nov2708", "Dec2508", "Jan0109", "Jan1909",
"Feb1609", _
"Apr1009", "May2509", "Jul0309", "Sep0709", "Nov2609",
"Dec2509")

--
Thank you

Dave