All of my Macros Stopped working! Is there a reference I might have unchecked?

[nbaj2k]

I was working on finalizing one of my macros, when all of my macro
stopped working. They all involve emailing at the end so I figure
that was it.

When I try to run one it comes back and says

"Compile Error: Wrong number of arguments or invalid propert
assignment"

It then comes back and highlites the word "Format" on this line.

olMail.Subject = "Daily Reports from " & Format(Date - 1, "mmm-dd-yy")

If I get rid of the word Format, it selects format on another line.
have the Outlook reference checked as well as the Applicatio
extensibility.

Does anyone have any idea what could have gone wrong? I'm now unabl
to generate any of my reports!

Any help would be great!

~

 

[Guest]

I know that you indicated that your reference to Outlook is checked, but are
any of the refernces tagged with "Missing:". The error you describe sounds
suspisciously like a missing reference...

 

[nbaj2k]

I didn't see that. I did get it to work. I opened a new file and
copied all of the code into it and it worked fine. I think it was a
reference issue somehow still, but atleast its back up and working
PHEW!

Thanks,

~J

 

[Guest]

I suggest you have created a procedure named format or a variable named
format.

If so, rename it.