open excel file automatically on specific date

[feidifeidi]

Hi!
if i have different date in E2 to E20. can i set excel to auto open when the date today matches the date from E2 to E20?
Or can it send a email reminder etc?
i tried google about it but with little information. tried for many days but cannot get it.

Thank you very much all the experts!!

[vba_php]

it depends on where you want to open the excel app from. say for instance, you want to open it from another instance of excel that is already open (and inside an external workbook). all you would have to do in that case is open your target workbook with code, point to the cell that has the desired date of open, then if it IS that date, open a 2nd instance of the program. however, if you are asking whether or not you can open the actual Excel application through VBA code, yes you can. you can open it using that language from another other office program if it is open.

the other thing you can do, which is probably something you have not dealt with, is open it using the SHELL of windows. the CMD prompt, in other words. via running a .bat file is an option. furthermore, if you want to get really clever, you can also do this task with virtually any desktop coding package available => PHP, Python, C, etc...

and yes, you can send an email reminder to someone too. I assume you mean from outlook? email reminders in outlook are part of the object model of that program. and you can get that to happen within VBA itself by writing code like this:

https://docs.microsoft.com/en-us/off...tlook.reminder

[feidifeidi]

Hello vba_php! thank you for your reply!
for the SHELL of windows that you suggested is it very difficult?
if the first one which is the open the excel app how would it be done with VBA? sorry, i really have very little VBA skill. how do i target workbook with code?
thank you!

[vba_php]

here are a couple of responses to what you have asked:

for the SHELL of windows that you suggested is it very difficult?

see the following article to guide you on how to use that function:

https://docs.microsoft.com/en-us/off...shell-function

SHELL runs programs (executables), and you can either specify the full directory path of the program you want to run, or in some cases, you can simply type in the name of the file with the extension. so, for excel, you can actually type this into the VBA code editor:

Please Login or Register  to view this content.

and it will open excel for you. a new instance if excel is already open. and if it is not open, excel will open for the first time right in front of you.

if the first one which is the open the excel app how would it be done with VBA? sorry, i really have very little VBA skill. how do i target workbook with code?

if you want to open a new workbook when running code from inside an excel application (a workbook that is already open), you would write this:

Please Login or Register  to view this content.

does this help?

[feidifeidi]

Hi vba_php thank you for being patient to answer my question.

i attached an example file.
i want this file to open up when any of the "renew" column header show Yes.
is it possible? i read through shell function but i am totally confused by it.

Thank you in advance!

[vba_php]

i want this file to open up when any of the "renew" column header show Yes.

you want WHAT file to open up? the one you uploaded? the one that already has a RENEW column? you'll probably need a button. behind the button:

Please Login or Register  to view this content.