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

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!

~

--
nbaj2
-----------------------------------------------------------------------
nbaj2k's Profile: http://www.excelforum.com/member.php...fo&userid=3648
View this thread: http://www.excelforum.com/showthread.php?threadid=57177

All of my Macros Stopped working! Is there a reference I might hav
 

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...
--
HTH...

Jim Thomlinson


"nbaj2k" wrote:


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

When I try to run one it comes back and says

"Compile Error: Wrong number of arguments or invalid property
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. I
have the Outlook reference checked as well as the Application
extensibility.

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

Any help would be great!

~J


--
nbaj2k
------------------------------------------------------------------------
nbaj2k's Profile: http://www.excelforum.com/member.php...o&userid=36480
View this thread: http://www.excelforum.com/showthread...hreadid=571772

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

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


--
nbaj2k
------------------------------------------------------------------------
nbaj2k's Profile: http://www.excelforum.com/member.php...o&userid=36480
View this thread: http://www.excelforum.com/showthread...hreadid=571772

All of my Macros Stopped working! Is there a reference I might hav
 

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

If so, rename it.

--
Regards,
Tom Ogilvy


"nbaj2k" wrote:


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

When I try to run one it comes back and says

"Compile Error: Wrong number of arguments or invalid property
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. I
have the Outlook reference checked as well as the Application
extensibility.

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

Any help would be great!

~J


--
nbaj2k
------------------------------------------------------------------------
nbaj2k's Profile: http://www.excelforum.com/member.php...o&userid=36480
View this thread: http://www.excelforum.com/showthread...hreadid=571772