Hi Paul,
Thank you for your reply. Thanks a lot for your suggestion. I've changed to
use another way for the time being.
Hope you have a very nice day!
Cheers
On Thursday, 18 February 2016 20:59:51 UTC+8, Paul Schreiner wrote:
>
> "Without opening the file manually"..
> I think there's a way
"Without opening the file manually"..I think there's a way to do that, but from
what I understand the technique still requires the excel file with the macro to
be open.
Instead, you can write macro that tests for the current date/time and changes
the cell when the file is opened.(it would then s
Hi all,
I have an xlsm sheet and would like to change the cell content in Column A
at 9am everyday. If cell value in column A equals to "Yes" today, then it
needs to be changed to "No" automatically at 9am tomorrow without opening
the file manually. May I know how can I get this done? Please s
