Changing System Date / Time

[Logit]

.
Is there a means using VBA to change the system Date / Time ? Would you be so kind to provide that code ?

Any example (very few) I've found on the internet do not work.

Thank you.


These are the only examples I've found :

Please Login or Register  to view this content.

Please Login or Register  to view this content.

[AliGW]

So, which ones have you tried that don’t work for you? It would be sensible to say rather than having to respond several times with, “No, already tried that - doesn’t work”, which will be frustrating for helpers.

[Logit]

.
Here is the answer to my question :

To do this you need to be running Excel as an Administrator or you will get a RunTime Error 70 'Permission denied'

To run as adminsitrator right click the Excel icon - click 'More' and run as administrator. You can then
change the system date with:-

Please Login or Register  to view this content.