This workbook code correction

[mukeshbaviskar]

Dear Friends,
I have 2 macros in my file. 1. newyear 2. anniversary. I have not inserted anniversary macro in the file But I want to run anniversary macro daily and newyear macro on 1st January of each year in future regularly.

The present code in this workbook code works fine for anniversary macro but not for newyear. Please assume that there is a anniversary macro in the file and call event in this workbook code 'call anniversary' and suggest me a correction.

Thanking you in anticipation.

Sincerely,

Mukesh

[stnkynts]

This will run a macro if it is January 1st. Assuming you open the workbook on January 1st

Please Login or Register  to view this content.

[mukeshbaviskar]

Hi stnkynts,
Excellent! It's working fine. On 1st January the output of this code will be available. Now only anniversary macro is running so that the code is working fine as per my requirement.

Thank you for suggestion.

Sincerely,

Mukesh

[mukeshbaviskar]

Hi stnkynts,
Sorry for posting again in solved thread. I changed the date 24/12 for testing but it it's not giving me the required output. It delivers only anniversary mails and not newyear mails. My date format is DD MM. So I changed it to 24/12 in cell b5.

Please see the attached file this workbook code and correct me.

Sorry and thank you.

Sincerely,

Mukesh