As ALWAYS, post YOUR code for comments

if day(date)=1 then
do this
else
do that
end if

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Dave" wrote in message
...
Hi,

I have a macro that opens a file and pulls any outstanding tasks from the
previous day.

I have a problem when it is a new month because the previous month's file
is
called MyFileMarch2010.

The macro now looks for MyFileApril2010. How do I capture the error and
look
for the previous month's file if it is the first business day of the
month?

Any help or suggestions is appreciated.
--
Thank you

Dave