This is a tutorial for creating a custom login window for an excel file using VBA. This allows the user to enter their private password and login. If the user does not remember the password, they can use the "forgot password" feature and the password will be mailed to their registered email.
Code for Mailing:
Dim outlook As Object
Dim newEmail As Object
Dim xInspect As Object
Dim pageEditor As Object
Set outlook = CreateObject("Outlook.Application")
Set newEmail = outlook.CreateItem(0)
With newEmail
.To = emailid '''declare it first with the mail id you want to send to
.Subject = "Password Recovery"
.body = "Hi " & user_name & "Your Password is: " & Password
.DeleteAfterSubmit = True
.Send
Set pageEditor = Nothing
Set xInspect = Nothing
End With
Set newEmail = Nothing
Set outlook = Nothing
TAGS:
#excel #microsoft #microsoftexcel #office #word #o #powerpoint #business #cursodeexcel #data #msexcel #curso #cursoexcel #powerbi #exceltips #motivation #datascience #microsoftoffice #n #aprenderexcel #planilhas #dicasexcel #windows #dashboard #cursos #ado #exceltraining #like #excelbasico #dataanalytics
#youtubeislife #subscriber #youtubeguru #youtubecontent #newvideo #subscribers #youtubevideo #youtub #youtuber and #youtubevideos
#excel #microsoft #microsoftexcel #office #word #o #powerpoint #business #cursodeexcel #data #msexcel #curso #cursoexcel #powerbi #exceltips #motivation #datascience #microsoftoffice #n #aprenderexcel #planilhas #dicasexcel #windows #dashboard #cursos #ado #exceltraining #like #excelbasico #dataanalytics
#msexcel #excel #microsoftexcel #microsoft #exceltips #exceltraining #office #msword #msexceltraining #exceltricks #data #spreadsheet #msoffice #excelfunctions #microsoftoffice #business #learnexcel #spreadsheets #excelshortcuts #msexceltips #dataentry #excelformulas #accounting #exceltutorial #advancedexcel #excelskills #excelprofessional #vlookup #powerpoint #mspowerpoint #excelfunctions #microsoftexcel #exceltips #excel #excelformulas #msexcel #exceltraining #exceltricks #microsoft #microsoftoffice #excelshortcuts #excelspreadsheets #excelprofessional #learnexcel #advancedexcel #excelskills #onlinetrainingforeveryone #exceltutorial #vlookup #advancedexceltraining #officeproductivity #exceltutorials #spreadsheets #excelinterviewquestions #excelvba #excelmacros #msexceltraining #intermediateexcel #exceltestforjobinterview #howtoanalyzedata
#excelvlookup #excelforbusiness #msexceltips #exceltest #vadimmikhailenko #dataanalysis #sap #exceldashboard #pivottables #datavisualization #powerpivot #datamodeling #microsoftaccess #microsoftproject #microsoftpowerbi #microsoftexceltraining #microsoftword #powerpoint #match #index #formulas #exceltipsandtricks #functions #office #excelexpert #datamanagement #kursusprogramming #kursusdesign #follow #personaldevelopment
6 авг 2024