Track Changes Based On Login Name
Dec 21, 2006
I've been looking around for a way for Track Changes to reference the loggedin username of the workstation rather than the name in Excel registration.
I found this
Function UserNameWindows() As String
UserNameWindows = Environ("USERNAME")
End Function
: on this board and another blog.
But I don't know how to enter it to make this work. I had read you make it a new module and assign a formula, but the most I could get through was opening the VBA editor for the workbook, creating a new module, and pasting the code. Changes would still reference the Excel registration name, not the Windows' logged in username.
View 9 Replies
ADVERTISEMENT
Jul 20, 2009
I need to create a login username and password form which pops up when excel worksheet is open
Does anybody know the instructions for this task
View 9 Replies
View Related
May 13, 2008
how can I login to a website using vba. I googled many examples but still failed.
View 9 Replies
View Related
Apr 20, 2005
I want it so that when the workbook opens it prompts for a username and password. You can also have a button for "register" etc. Which will send you to a website.
View 9 Replies
View Related
Jan 14, 2008
I use a tool that connects to Salesforce.com. It is an xla addin. It references a toolkit that is installed...
View 3 Replies
View Related
May 31, 2013
I have below piece of code which I'm not sure how to finish up. What I'm trying to do is have 'Username' and 'password' entered before logging into the workbook. It does not have to be 'UserForm" if it is possible, but it would be useful if we use Ucase...
I'm just not sure how this code works with
"Sub sUserLogon(strStandardID As String, strPassword As String)"
stated in this way..
VB:
Sub sUserLogon(strStandardID As String, strPassword As String)
Dim strUserName As String
Dim StrMessage As String
Application.DisplayAlertsAlerts = False
StrMessage = "User Logged In"
[Code] ......
View 2 Replies
View Related
Dec 6, 2013
[URL]
Basically I’m trying to create a login userform that launches once the database opens.
Userform = LoginTextbox = UserformTextbox = PasswordCommand Button = UserloginCommand Button = UsercloseSheet containing passwords = Userpasswords
Usernames are stored vertically in the A column, and Passwords vertically on the B column both starting from row 1.
I’ve been using code found at [URL] but I’m struggling to make it work. Some of the variables listed below may be useless but I’m not entirely sure so I’m sceptical about removing them. !
VB:
Option Explicit
Dim ws As Worksheet
Dim Userpasswords As Worksheet
[Code]....
View 5 Replies
View Related
May 19, 2014
I'm trying to login to [URL] ...... using VBA. I cannot share login details. How it might be able to work?
View 3 Replies
View Related
Mar 4, 2014
I am quite new to the excel vba. I am trying to create a login screen
So whenever i open my excel sheet, the first thing should happen is that there should be a login screen and ot should ask for password and id. Once you provide the login id and password, you would proceed to the next screen.
View 2 Replies
View Related
Jul 16, 2008
I have an excel file where different people have to make their comments. So far I have sent out the files on email and they sent it back and then copied their comments to the original file, but from now on I would like to share the file and let them to write in their comments.
In order to make it professional I would like the file to work as following (lets suppose that I am Mr.X and I have to write my comments in row 2,6 and 9):
1. When I (Mr.X) open the excel file, there is a pop up message box with a drop down list saying: "Please select your name:"
2. In the drop down list I select my name (Mr.X) and I press OK.
3. Then I get logged in the file and I will see rows 2,6 and 9 only.
4. After making my comments I save the file and log out.
As for the example lets assume that there are 3 people who are making the comments. Mr.X /rows 2,6 and 9/, Mr.Y /rows 1,3 and 8/ and Mr.Z /rows 4,5 and 7/
View 14 Replies
View Related
May 2, 2013
I am looking to further improve this code by adding the functionality of logging to a secure HTTPS server using username and password.
Code:
Sub TestFileExistsandDownload()
'This code will test a web address to see if a file exists
'If the file exists, it will download the file.
' It's a mixture of code retreived from 2 sites:
' [URL]...
' [URL]....
[Code]...
View 1 Replies
View Related
Jan 13, 2014
I am attempting to use VBA to open a webpage and then login. Below is the code I have so far:
Code:
Sub Test()
Dim IE As Object
Set IE = New InternetExplorerMedium
With IE
.Visible = True
.navigate ("url")
[Code] ........
Here is the HTML Code of the website:
<form target="_top" name="Logi<wbr>n" method="POST" action="/login.fcc"></form>
<label for="firstname">User Name</label>
<input class="textbox2" onkeypress="javascript:processkey(window.event)" name="USERNAME" type="TEXT">
[Code] ........
An error occurs within the second With, stating that the object variable or With block variable not set.
View 5 Replies
View Related
May 1, 2007
if it's possible to add a login when you open a workbook and keep a log of who has logged in with the time noted......or am I being a bit optimistic?
View 9 Replies
View Related
Oct 14, 2009
I'm trying to use the CreateObject("MSXML2.XMLHTTP") technique to log in to my Amazon Seller Central account and extract the HTML page source of the URL. However, I simply haven't been successful with getting it to log in. I should note that I know very little about this technique, and simply copied and slightly modified the code from a website. It works when there is no log in. Here's an example of the
Dim URL As String: Dim HttpRequest As Object
URL = "https://sellercentral.amazon.com/gp/orders/fba-order-details.html?ie=UTF8&orderID=123-4940-3939039"
Set HttpRequest = CreateObject("MSXML2.XMLHTTP")
HttpRequest.Open "Get", URL, False
HttpRequest.Send
This is the code I use to get the page source when I don't need to log in. However, the URL I'm now trying to get to requires me to log in first. I've come across a couple different sites that offer the following techniques:
1) URL = "https://usernameassword@sellercentral.amazon.com............."
2) HttpRequest.Open "Post", URL, False, username, password
View 2 Replies
View Related
Dec 15, 2006
So I have some data that I'd like to extract from some financial sites that I'm a member of (one in particular is investors.com). I try and pull stock info from the site, but I have to manually initiate a new web query, go to the website, login, then cancel the web query for the macro on my spreadsheet to start pulling information. What I'd like to do is have two cells referencing my user id and password, and then click a button that will goto the website from excel, login, and allow the extraction of financial info to occur.
View 6 Replies
View Related
Apr 12, 2007
I want the userform to display an input box asking the user to enter their 'login ID'. This has to be either "SUPERVISOR" or "STAFF".
Upon correct entry i need it to then display another input box asking for a 'password'. This needs to be "SHOES" for both logins.
If the login is not equal to SUPERVISOR or STAFF I need a message box displaying "username incorrect". and for it then to show the input box requesting the 'login ID' again.
Again if the password is not equal to "SHOES" to display a message box displaying "password incorrect" Then show the input box requesting the password.
Upon correct entry for both the username and password i would like my other userform to show. This is displayed by:
Load UserForm1
UserForm1.Show
I would like the correct 'username' to be displayed in cell "D27" on the active sheet and 'password' to be displayed in cell "F27" also on the active sheet.
If there is a way to display the password using asterix's for security that would be useful.
View 9 Replies
View Related
Jun 4, 2014
I have a userform (Login), which allows you to login by entering your username, password and by selecting your role.
When you enter the username, password and role and click on submit, it shows another userform (Activities).
Now what I want is, when i enter username, password and select the role as team manager and click on submit, it should show the userform - "Manager_Login". For all other roles, it should show the userform - "Activities".
The usernames, passwords and roles are on the sheet - "User Access".
View 3 Replies
View Related
Feb 22, 2014
I found some username and password login code that I am editing for my needs, but I am having some trouble with it. I keep getting run time error '448': Named argument not found on the following line:
MatchCase:=False, SearchFormat:=False)
[Code] .....
I have also attached my workbook.
Equipment Return Log.xlsm
View 2 Replies
View Related
Jun 28, 2012
I need to get data from a website that requires to log-in, so i set this Vba, and i get an error "object dosent support this property or method"?
Sub GetTable()
Dim IEApp As Object
Dim IEDoc As Object
Dim IETable As Object
Dim clip As DataObject
Set IEApp = New InternetExplorer
IEApp.Visible = True
[code]....
View 1 Replies
View Related
Apr 22, 2013
Is there any way in which I could get Excel to login automatically to this website [URL] .... for obvious reasons I cannot divulge the username or password.
I have managed to get excel to open the site.
View 5 Replies
View Related
Aug 5, 2013
I need to write one Macro program for below logic.
A
B
C
123
123
‘TRUE’
123
234
‘TRUE’
[code]......
View 3 Replies
View Related
Dec 7, 2006
I have a worksheet that is going to be used my approx. 10 people at my company. I want to give access to certain menus to a few people and other menus to others. I have 2 custom menus. One is for each group, but I don't want to allow access to the other groups menu. Is there a way to create a way of logging in via username and password so that excel can display only the correct set of menus depending on who is using the sheet at the time? I think there is a way that excel can recognize the windows login and password for each person and maybe I can use that? If so, how do I then set it up to display only the correct menus to certain users?
View 9 Replies
View Related
Apr 12, 2007
I have come up with the idea to create a userform to act as a login page for my project. I have the project complete and need a way to protect it. I want the userform to display an input box asking the user to enter their 'login ID'. This has to be either "SUPERVISOR" or "STAFF". Or If I have a table of 'users' and 'passwords' in sheet (USERS) to match them against that if it is easier?
Upon correct entry i need it to then display another input box asking for a 'password'. This needs to be "SHOES" for both logins. If the login is not equal to SUPERVISOR or STAFF I need a message box displaying "username incorrect". and for it then to show the input box requesting the 'login ID' again. Again if the password is not equal to "SHOES" to display a message box displaying "password incorrect" Then show the input box requesting the password. Upon correct entry for both the username and password i would like my other userform to show. This is displayed by:
Load UserForm1
UserForm1.Show
I would like the correct 'username' to be displayed in cell "D27" on the active sheet and 'password' to be displayed in cell "F27" also on the active sheet To show who is 'Logged On'. If there is a way to display the password using asterix's for security that would be useful.
View 6 Replies
View Related
Mar 13, 2008
I have a workbook which, on opening, shows a logon form and depending on the username and password entered only certain sheets open - there are about 10 usernames and passwords - i have only included 2 to keep the code a bit shorter. I got the code below from here and it works perfectly but I want to make it a bit easier to add new usernames and passwords and am thinking of using a Vlookup table. The code i currently use is:
Option Explicit
Const sName1 As String = "Lisa"
Const sName2 As String = "Philip"
Const sPw1 As String = "update"
Dim sPW As String, sUser As String
Dim sMsg As String, sTitle As String, sStyle As String
Dim iCounta As Integer
Private Sub cmbValidate_Click()
sTitle = "Incorrect Password"...........
View 5 Replies
View Related
May 23, 2014
I am trying to create a log-in page on a userform, frmlogin in "sheet3." The userform is simply a textbox, Username (txtuser) and a textbox, Password (txtpass). Command Button is cmdcheck
I want the User to enter their username and password and for my macro to verify that they match referencing data in a seperate worksheet, (Sheet6).
Upon verification I want the user to be unloaded on "sheet1"
I am currently getting this message: "unable to get vlookup property of the worksheetfunction class"
VB:
Private Sub cmdcheck_Click()
Dim Username As String
Username = txtuser.Text
[Code]....
View 9 Replies
View Related
Jan 30, 2014
I have a workbook (attached) which has a button that would enable a user login using a username and a password. The usernames and passwords are configured on an hidden sheet (config) in Columns A to D. In column D, access level is selected to be either "FULL" or "LIMITED" which gives access to an extra button which enables user to be able to create new users, change passwords and all.
The issue I have is, the user I have configured to have FULL access does not have it as the button which gives access to this functionality does not come up.
ADMINISTRATOR 1 - password1 (has full access)
ADMINISTRATOR 2 - password2 (has limited access)
ADMINISTRATOR 3 - password3 (has limited access)
Please see attached Login Sample.xlsm.
View 7 Replies
View Related
Apr 23, 2013
i currently have an excel based application with VBA code. I'm trying to add some controls around the app by prompting user for login and password credentials prior to ODBC connection at runtime. So when application is launched, prompt appears, user enters login and password, if correct, it goes on to verify user has ODBC connection at runtime.
View 2 Replies
View Related
Jul 18, 2014
I want have a chart that use Formula result to update automatically. I know there is some vb methods to do this but my job is different and that ways work when values enter manually but i need a way that use formula result to update and don't make chart as long as existing values. I attached a sample of i need and i did explanation on it. The Salesman's are enter to column A by a VB and Their values of cost or earning are enter by a formula.
View 2 Replies
View Related
Mar 7, 2014
I am creating a login system for two users on a excel worksheet. I have the two users on a drop-down list, Maria and Andrew, which then requires a password entry. This is linked onto a data validation to make sure that the password matches the data table.
After, I then click on a macro, which, when successful, takes me from sheet 1 to sheet 2.
My problem is that I need to have it so that Maria is taken from Sheet 1 to Sheet 2, and Andrew from Sheet 1 to Sheet 3.
View 1 Replies
View Related
Aug 9, 2007
I need some vba code that will enable the users of my spreadsheet to populate a range of active cells with their Windows Username,time and date.
Quite simply I have approx 30 people accessing one spreadsheet and each person needs to update some info on the page.. So what I want is a time stamp so i know at what time they finished their updates and will also confirm their usernames...
View 12 Replies
View Related
