VB

[krishnaa_kumarr88]

Hi all,
Thanks for looking at my post. I am wondering ,
1. is there is any way of sending automatic warning email if the excel is not opened for 8 days ?
2. Is it possible to delete the complete spreadsheet once in a year automatically and i would like to get automatic PDF document once the spreadsheet is deleted.
Please help me guys,
Thanks.

 

[Reggie74]

I'll probably use Windows Scheduled tasks for both (1) and (2)

For (1) :- you could 'tap' into Control Panel's list of installed programs .. search for the Excel Application and check to see the last modified date (extract it and compare with current date > 8 days then
use your e-mail's object library and send the e-mail ??

For (2) :- mmm .. here you would need to know which spreadsheet is deleted (google a bit) .. knowing this and the rest will be easy ... i guess ...

I know this is not giving you a solution but suggestions for further research to finding a solution to your problem ..

Hi all,
Thanks for looking at my post. I am wondering ,
1. is there is any way of sending automatic warning email if the excel is not opened for 8 days ?
2. Is it possible to delete the complete spreadsheet once in a year automatically and i would like to get automatic PDF document once the spreadsheet is deleted.
Please help me guys,
Thanks.

 

[krishnaa_kumarr88]

Thanks a lot.