login

Have a login details on Sheet1 as follow Sheet1 <tbody> A B C D E F User Name password Anna 12565 Login James 65234 Jimmy Susan 65845 12356 Michael 33654 Jimmy 12356 Koda 88751 </tbody> I have the follow code at...

Hi, I have 3 sheets in a Workbook named in the brackets. 1. The main LOGIN sheet(Login) 2. Second sheet containing list of 101 usernames and passwords in column A and Column B respectively (Admin) 3. The sheet which you navigate to after logging in successfully. (Metric) I need a VBA code to...

I cannot figure this one out. When I go to upload a .csv to an online uploader, I can navigate and click every element I need. I can find the path/file and click "OPEN" and then successfully upload the file. The problem is: When the file dialog is up, VB stops, due to the dialog focus. Much like...

Hi guys, Can someone help me out with a code that will login to below website using my credentials? Website: https://yardi.starlightinvest.com/voyager6008sp17/pages/Login.aspx Thanks.

Hello, First post/long time lurker! I want to visualise the amount of time a telephone Agent has been logged in, per 15 minute interval. The below example shows the time an Agent has been on the phone, went to a break and then returned on the phone. I've got about 95% of the way there with...

I am trying to get to the login screen and automatically enter the username and password and clicking on Enter. I have been successful on other sites but the following site has a "Login" button that functions as a dropdown menu. I can't figure out how to navigate past the dropdown menu to get...

Hi good day! Sorry if my post is about how to create login form with login and logout records. I am beginner in excel so please help me. I watched some tutorial about how to create userform but I cant write the codes on how to form with records of login and logout. Sorry if my english is not...

Hello! I am trying to write a macro and the first thing I need to do is log in to a website. It appears that I am able to have the macro open up the website, enter the username and password but I'm struggling with getting it to submit. Can someone tell me what I'm missing here? Dim HTMLDoc As...

I have a Workbook with about 90 sheets that will be used by different users at different times, I have created a Home Sheet and a Combobox that will allow user to jump to the sheet they select, I want to create a login form with Username and password for some sheets that only user with password...

Hello Everybody. I'm struggling with an automatic login. div id="userid01" input type="text" name="USER" tabindex="1" div id="password01" input type="password" autocomplete="off" name="PASSWORD" tabindex="2" The most classic of my numerous attempt is the following...

Option Explicit Private Trial As Long Private Sub cmdCheck_Click() 'Declare the variables Dim AddData As Range Dim user As Variant Dim Code As Variant Dim result As Integer Dim TitleStr As String Dim Current As Range Dim PName As Variant Dim msg As VbMsgBoxResult 'Variables user =...

So I made a worksheet, and want to start selling it. The thing is, I want to make a login system, making a login system is simple, but the one I want to make an online login system for my sheet, so there can be only 1 user at a time loged in it for a specific login. Is there a tutorial on how...

Hello everybody. I need a help for login in one site. My matter is that, in a different way respect my previous experiences, I cannot univocally identify the login and password fields. For example, below you can see the framework of the login field, analysed seven times. input id="lQ8g5"...

Hey I want a simple login screen for my access file. I have it all working with users in a table. this code works fine If Me.txtPassword.Value = DLookup("Password", "Access_Table", "[User_ID]=" & Me.txtUsername.Value) Then lngMyEmpID = Me.txtUsername.Value 'Close logon form and...

One of my friend prepared some checklist where all the required staff was asked to put processor id in one column and in other the current date and time. When we double click the cell then automatically the processor id and date & time get pop up. I tried from my end but did not get any answer...

I am trying to login to a website through a VBA. The VBA completes the username and password, but won't click the submit button. This is my VBA: Sub Login() Dim ie As Object Set ie = CreateObject("InternetExplorer.Application") ie.navigate "www.something.com"...

I made one userform which will help me to protect my code when user open my file,my user form will pop up evrething is working fine except this 3 things 1)i need few more changes in this program I have added Label 1 which is used to show "windows username" it is not visible 2)i have 2 text box...

Hey guys, I am currently writhing a code in VBA excel to automate my data entry from a user form to IE. I am easily able to add my data in text box's but I am currently having issues clicking the login button. Here is the HTML code when I click inspect on the login button itself: <input...

Hi; I have a spreadsheet that I need to calculate the date difference in days between each row that has the same LogIn. So I need the date difference in days between row 1 & 2, then 2 & 3, because the LogIn is the same, but row 4 has a new LogIn that would need to begin. The sort would be on...

Hi guys, I have a workbook that on opening, uploads a user form login page. Following the login, the login user form closes and opens the main user form. I want to have a welcome message play once only when the main user form opens. I've tried googling various ways to do it but so far I've...