Capture user name, login and logout times and calculate hours worked
We can capture the user-name, login and logout times and then calculate the number of hours worked automatically using Excel VBA.
We need 3 files:
1. The file in which we wish to work
2. Log-details file
3. User-name and password file against which we can confirm the correct user-name and password entry of the person logging in.
When we open our workbook a login form is presented. After confirming our credentials we can start working. In the process our user-name and login time is recorded. We ensure that the user cannot close the workbook without logging in. This is done by disabling the cancel button 'X' on the right corner of the user-form using an IF statement.
Most of the details have already been discussed in earlier videos. A few links are given below:
1. http://www.exceltrainingvideos.com/how-to-get-multiple-values-from-closed-workbook-using-vba/
2. https://youtu.be/XnKRHmgDn84 - find next blank row
3. http://www.exceltrainingvideos.com/copy-worksheet-from-another-workbook-rename/ - how to check whether a workbook is already open
After finishing our work we close the file and the macro or VBA code automatically records the logout time.
In the log-details file we run an interesting macro that calculates the amount of time we have worked.
Видео Capture user name, login and logout times and calculate hours worked канала Dinesh Kumar Takyar
We need 3 files:
1. The file in which we wish to work
2. Log-details file
3. User-name and password file against which we can confirm the correct user-name and password entry of the person logging in.
When we open our workbook a login form is presented. After confirming our credentials we can start working. In the process our user-name and login time is recorded. We ensure that the user cannot close the workbook without logging in. This is done by disabling the cancel button 'X' on the right corner of the user-form using an IF statement.
Most of the details have already been discussed in earlier videos. A few links are given below:
1. http://www.exceltrainingvideos.com/how-to-get-multiple-values-from-closed-workbook-using-vba/
2. https://youtu.be/XnKRHmgDn84 - find next blank row
3. http://www.exceltrainingvideos.com/copy-worksheet-from-another-workbook-rename/ - how to check whether a workbook is already open
After finishing our work we close the file and the macro or VBA code automatically records the logout time.
In the log-details file we run an interesting macro that calculates the amount of time we have worked.
Видео Capture user name, login and logout times and calculate hours worked канала Dinesh Kumar Takyar
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
![Excel 2016 Advanced](https://i.ytimg.com/vi/F4b-GnvRN4k/default.jpg)
![How to create User Login Form in VBA and Excel (Step by Step Guide)](https://i.ytimg.com/vi/sjmvT51vDYs/default.jpg)
![Attendance Login Logout UserForm using Excel VBA](https://i.ytimg.com/vi/OvTBwebfpmA/default.jpg)
![How To Track Logon Sessions with Windows Security Log](https://i.ytimg.com/vi/8B04-RXMtWY/default.jpg)
![Automatically Hide Workbook in Background and View only User Form](https://i.ytimg.com/vi/N_eXcE-5J8w/default.jpg)
![Excel VBA Introduction Part 2 - Writing Your First VBA Macro](https://i.ytimg.com/vi/7RVGdA9AhrY/default.jpg)
![CREATING SIGNUP WITH LOGIN WITH SESSION AND LOGOUT IN ASP.NET MVC (URDU / HINDI)](https://i.ytimg.com/vi/x8jLE7VqwLw/default.jpg)
![2017-02-28 - Excel - Formulas and Functions](https://i.ytimg.com/vi/cyHA99_J1tQ/default.jpg)
![Create Login Tracking Database Part 1: MS Access](https://i.ytimg.com/vi/nWgLaehaqnc/default.jpg)
![](https://i.ytimg.com/vi/VfJdsymxIEY/default.jpg)
![The AMAZING TRICK To Add Different User Security Rights to ANY Excel Sheet and User Login](https://i.ytimg.com/vi/0ahYoy5L3ec/default.jpg)
![Develop a LOGIN LOGOUT Application in EXCEL by MACRO](https://i.ytimg.com/vi/UJllha_6reA/default.jpg)
![Time & Motion Tracker in Excel - Step by Step Tutorial](https://i.ytimg.com/vi/flcbhfrtl20/default.jpg)
![Tracking Changes to Data in Microsoft Access - Audit Trail - Log User Activity - Record Edits](https://i.ytimg.com/vi/3sIHMGxugL0/default.jpg)
![Smart Attendance Manager in Excel VBA](https://i.ytimg.com/vi/gu2PRtl-mzc/default.jpg)
![User level security in Excel Workbook for different worksheets](https://i.ytimg.com/vi/jGhkLeHMEUA/default.jpg)
![Automatically Timestamp Data Entries in Excel](https://i.ytimg.com/vi/gIPdx4-rqGg/default.jpg)
![How to Create a Login System in Excel Using VBA](https://i.ytimg.com/vi/ttLWci44SwI/default.jpg)
![How To Create An Excel Data Entry Form WITHOUT A UserForm](https://i.ytimg.com/vi/SnA3cct-2IM/default.jpg)
![Get Data from Outlook into Excel worksheet](https://i.ytimg.com/vi/35g8J2mzdUY/default.jpg)