vba macro to run a macro at a specific time

[Shereena Kareem]

Hi all,
I have a macro that need to run everyday at 5.30 pm... So can i automate this.... Means a macro to run my macro everyday at 5.30 pm.... Thanks in advance..

Sk

 

[eibi]

Shereena,

Welcome to the forums.

Perhaps you'll find the direction you're looking for at this link:

http://www.mrexcel.com/forum/excel-questions/48654-running-macros-specific-time.html

But only if you will already have the workbook open when it's time to run the macro...

 

[YasserKhalil]

Try this attachment..
The time is related to 24 hours system so 05:30 pm should be 17:30

 

[Shereena Kareem]

Try this attachment..
The time is related to 24 hours system so 05:30 pm should be 17:30

Thanks for the reply...
But this macro is not working for me... my workbook is always closed... any other way to solve this...? Am using Excel 2013.

 

[Shereena Kareem]

Shereena,

Welcome to the forums.

Perhaps you'll find the direction you're looking for at this link:

http://www.mrexcel.com/forum/excel-questions/48654-running-macros-specific-time.html

But only if you will already have the workbook open when it's time to run the macro...

Thanks for the reply...
But this macro is not working for me... my workbook is always closed... any other way to solve this...? Am using Excel 2013.