E
Eric
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?
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?