Excel 2000 vs Excel 2002 Macro
 

Have a client with an Excel 2000 spreadsheet with extensive coding
involved. The primary function is to create a new worksheet, with
today's date when clicking a commandbutton on the first page. On my
machine running Excel 2000/WinME, it works great. On the client's
machine running Excel XP and WinXP, it fails with an error "Unable to
locate project or library". Clicking DEBUG, brings the client to:

ns = Format(d, "mmmmdd")

Where d is defined as a date (#4/8/2004#) and ns is a string.

I am thinking the error is not here, but somewhere else. It opens a
form asking for the current date. Does Excel 2002 handle forms
differently than 2000?