| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Reset system clock?
In the ThisWorkbook module, try
Private Type SYSTEMTIM wYear As Intege wMonth As Intege wDayOfWeek As Intege wDay As Intege wHour As Intege wMinute As Intege wSecond As Intege wMilliseconds As Intege End Typ Private Declare Function SetSystemTime Lib "kernel32" (lpSystemTime As SYSTEMTIME) As Lon Sub ResetClock( Dim lpSystemTime As SYSTEMTIM lpSystemTime.wDayOfWeek = - lpSystemTime.wDay = 2 lpSystemTime.wYear = 200 lpSystemTime.wMonth = lpSystemTime.wHour = 1 lpSystemTime.wMinute = 3 lpSystemTime.wSecond = lpSystemTime.wMilliseconds = SetSystemTime lpSystemTim End Su |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculating a future date using system clock & time remaining | Excel Worksheet Functions | |||
| Incremental time values based upon clock in and clock out times | Excel Discussion (Misc queries) | |||
| Change EXCEL Clock to Standard Clock or Military Time | Excel Worksheet Functions | |||
| Code referencing the system clock? | Excel Programming | |||
| Setting the system clock with excel | Excel Programming | |||
![AA2e72E[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
