VBA - Modify System Date / Time ?

Question

I have searched the Internet, this forum and many other forums re: VBA Excel to modify the system date and time.

Does anyone have sample VBA code they are willing to share that will modify the system date and time ?

Thanks.

Answer 1

Hi,

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:-

Sub ChangeClkDate()

Date = DateSerial(2018, 8, 5)

End Sub

and the time with

Sub ChangeClkTime()

Time = TimeSerial(14, 0, 0)

End Sub

Note. Despite being able to do it, I would need a very compelling reason to do so. Fiddling with the system can have effects that may not have been anticipated.

Answer 2

Mike :

Thanks for the answer. Just what I was seeking.