Open Secure Website And Paste Username And Password.
Jul 18, 2005
Trying to find a set of code that I can use to open a website that's predetermined, and enter in the users name and password automatically. And if possible, open a new email via the website, addressed to a person, and ready to browse for the file to attach.
The code I have is below.
Private Sub CommandButton1_Click()
'
storenumber = [$c$3]
If [$iv$2] = True Then
If [$iv$3] 0 Then
MsgBox ("Can't send with No Adjustments Checked & Items to Adjust, Please clear one")
End
End If
End If..................
View 9 Replies
ADVERTISEMENT
Aug 8, 2014
I have a spreadsheet (don't we all) that is currently password protected - you double click the file and need to input a password before it will open.
I have some code that will protect a workbook from changes and only unlock for specific usernames, and i wonder if there is some code that will do the following:
-User opens spreadsheet
-VBA looks at the username trying to open the sheet, for this example the username is Paul.Smith
-Paul.Smith is not one of the people who should have regular access to this sheet - so the VBA requests a password from him prior to opening the sheet.
My username opens the same sheet (galvin.paddy), VBA see's that my name is one of the 'Authorised Users', removes the password and opens the sheet for me ready for use.
View 14 Replies
View Related
Dec 5, 2012
I need to protect the VBA Password protected module from being hacked. Now a days there are VBA password recovery tools which are easily available on the net & can be downloaded to break the protected module. I have one as well.
I can use this tool to see break my password of a protected module. How to secure my VBA modules in a project.
View 8 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
Feb 7, 2007
I am using the below code to access a website with IE.
My next step (of many) is to Login to this website.
The login screen requires that I enter:
User Name:
Password:
How can I tell IE to enter my user name and Password?
Sub Macro2()
'
'Macro2 Macro
' Macro recorded 2/6/2007 by dsggodwin
Public Sub Goto_ToyotaSupplier_Click()
Dim EXP
Set EXP = CreateObject("InternetExplorer.application")
EXP.Visible = True
'put the webpage here
EXP.Navigate ("https://www.portal.toyotasupplier.com/skpi/SkpiGatewayServlet?jadeAction=NCPARTS_SEARCH")
End Sub
View 9 Replies
View Related
Feb 18, 2010
I'm trying to create a program that will automatically log in to a website that requires a username & password. I am able to enter the username and password in the correct text boxes, but I can not get the form to submit to approve the login. It refreshes and removes the password.
I have attached my code. The web url is inside it.
Sub IE_login()
Dim ie As InternetExplorer
Dim C
Dim ULogin As Boolean, ieForm
Dim MyPass As String, MyLogin As String
Set ie = New InternetExplorer
ie.Visible = True
ie.Navigate "https://applications.dacgroup.com/login.aspx"
'Loop until ie page is fully loaded
Do Until ie.ReadyState = READYSTATE_COMPLETE
Loop
View 9 Replies
View Related
Jan 9, 2007
code below, I need :
1) navigate to a web page
2) submit my userId and password
3) beeing redirected to a different url I have to menage this situation for passing url to
4) quering sub
I am using Excel 2000 with win98
Error 429 Can't create object:which one?
Public Sub First()
Dim obEx As Object
Dim obj As New MSHTML.HTMLBody
Dim strPass As String
Dim elUid As New MSHTML.HTMLInputElement
Dim elPass As New MSHTML.HTMLInputElement
Dim elSubmit As New MSHTML.HTMLInputElement
Dim strUid As String
Dim Desc As String
View 9 Replies
View Related
Jul 22, 2014
As part of my requirement, i'm trying to update some data into share path. While trying to access the share path, i'm being asked to key-in appropriate username & password. Windows alert will be opened when my code try to access share path, there I have to enter username & password using script.
Is there any way achieve this using VBA?
View 2 Replies
View Related
Oct 25, 2007
I am trying to log on to an FTP site and post a file through Excel VB. I have managed to open a new Explorer window and direct it to the URL, but I don't know what to do next. After navigation to the URL a Pop-Up Window comes asking for UserName and Password and I don't know how to supply it and click submit.
After I have completed that I will need to give the path of the file, click post, and close the window when it is done.
Here is what I got so far:
The commented out stuff is not working. I got it off a similar application that someone else in my company wrote that accomplishes a similar task.
Sub SConnect()
Dim IE As InternetExplorer
Dim IEURL As String
Dim IEDoc As HTMLDocument
Set IE = CreateObject("InternetExplorer.Application")
Set IE = New InternetExplorer
IE.Visible = True
IEURL = "https://something.com" .................
View 4 Replies
View Related
Nov 21, 2007
I'd like to automatically enter the username and password from a spreadsheet.
Currently, I've got a spreadsheet that has a login id in one cell and a password in an adjacent cell.
I click a button on the spreadsheet to call a hyperlink to a webpage while excell is using the copy function to copy the username to the clipboard.
Once the webpage loads, I just paste the username into the username box.
Then I go back to excel, copy the password, then back to the webpage and pastes the password.
This works good for me, but I'd like to make it a little bit better.
What I'd like to be able to do, if I had the username and password in one cell seperated by a symbol (say, "=" since usually don't use that one) then when I hyperlink to the webpage, I hit paste.
>> this time, when I hit paste, (maybe using some kind of a api code or something), excel pastes into the first box, *automatically* hits the [TAB] key, and paste the password.
View 3 Replies
View Related
Aug 20, 2008
I was able to get some help a while ago and hoping for someone to reply as well. Any one have ideas how to create a userform which will be use for username and password input? I know how to create one but is there anyway that the username and password will be stored as .txt file instead of using worksheet to store the data?
View 14 Replies
View Related
Jun 23, 2014
I trying to create a paperless petty cash system. I have my sheet all setup and calculating how I want. When a user makes an entry they Enter their name in column "W".
I am trying to overcome the problem of accountability. I need to achieve a cell calls for Username and Password and if correct the persons name is entered into cell then Row is locked to prevent figures being altered etc. But also if user made mistake they need to unlock it somehow someway
Sure this achievable from snippets of info I seen online but its way beyond my abilities. I realise a determined user can circumvent this if they wanted to.
View 5 Replies
View Related
Jan 30, 2008
I've been playing around with the API functions (specifically, InternetOpenURL) to retrieve the contents of an HTTP webpage and store the information within a text file, using Excel VBA. It works great for any "normal" webpage not requiring a "Username" and "Password" login. I can't find any examples on how this is done for a webpage requiring such a login? I've heard you can do this via sending the appropriate cookie to the server, but I can't find any documentation on the web? Does anyone have any idea on how this functionality is achieved?
View 9 Replies
View Related
Jan 3, 2011
I need a macro ie when a user opens a macro enabled workbook,he should be asked for a username and password to access workbook. Administrator should have right to create users with reset password rights
View 5 Replies
View Related
Jun 18, 2012
Using Excel2010 in Windows7. I have a UserForm
1: TextBox for Input Username (txtUsernameIn)
2: TextBox for Input Password (txtPasswordIn)
3) Submit Button (cmdSubmit1)
I have a Worksheet
ColA: Username
ColB: Password
And this entire Range A:B, I have named "UserRegister"
I have code, attached to the cmdSubmit1 button on my UserForm. The purpose is to allow access to a veryhidden Worksheet "ADMIN".
The code 'works' if I enter in both the correct UserName and Password (ie: the code completes & Admin sheet opens up).
The code 'works' if I enter in the correct UserName and the wrong password (ie: code completes it's run, my msg pops up to say there is wrong input, unloads the form & sheet ADMIN stays veryhidden).
However, if I enter the wrong username (with either right or wrong password) the code breaks and I get a debug error. I know my code is obviously wrong/missing something etc - but I can't work it out! The line of code highlighted on the break, is between the *** below
VB:
Private Sub cmdSubmit1_Click()
Dim Username As String
Username = txtUserNameIn.Text
Dim password As String
password = txtPasswordIn.Text
[Code] ......
View 9 Replies
View Related
Mar 23, 2014
I have Excel Sheet that open with user name and password.
Like if it's open my Admin - he can view all Sheets
If open by any user - it opens only users sheet.
Problem is once file is saved by any users, all hidden files get unhidden and Admin Sheet is open.
Requirement: if User1 saves file other sheets should not get unhidden.
View 1 Replies
View Related
Jul 24, 2008
I'm making a macro that logs into a password protected site, then checks to see if new work has been assigned to a given user. To to this it uses the navigate method on a frame within the main document and reads the innerhtml of that frame's document (repeats if multiple pages exist). The problem I'm encountering is that only sometimes does the last 2 lines of the code below (double brackets = censored) work as intended:
Set objIE = CreateObject("InternetExplorer.Application")
With objIE
.navigate "[[website login page]]"
Do While .busy: DoEvents: Loop
Do While .readystate 4: DoEvents: Loop
.Visible = True
With .document.forms("params")
.UserId.Value = "[[User ID]]"
.Password.Value = "[[password]]"
.submit
End With
End With
Do While objIE.document.readystate "complete": DoEvents: Loop
objIE.document.frames("WorkspaceRight").navigate "[[new frame destination]]" .................
View 9 Replies
View Related
Feb 2, 2010
I have bit of code that:
(1) opens another spreadsheet
(2) updates that spreadsheet
(3) saves that spreadsheet
(4) closes that spreadsheet
If the spreadsheet that requires updating is open by another user, I display a message indicating the file is open and no updates occured. There are about 20 persons within the organization that may have this file open? Is there away to display the username of the person who has the file open?.
View 4 Replies
View Related
Aug 21, 2013
getting the username of an unshared file on network. When I click on file I'll get this message "...already open by " its blank.
I have found 1 code but it is not working on office 2013. VBA function to get username of open file on network?
View 4 Replies
View Related
May 22, 2013
Is there a way to open a URL from a cell reference? For example, in cell B3 I would like to have the web site URL, Google, and have VBA reference the cell rather than a hard coded ActiveWorkbook.FollowHyperlink "[URL]".
View 4 Replies
View Related
Oct 24, 2007
I have been using some code which will open a blank email from a textbox with the appropriate email address in it with a single mouse click. Now I am trying to open a website in the same manner. See code the textbox code below:
Private Sub txtWeb_Enter()
Dim wLink As String
wLink = txtWeb.Value
On Error Goto err_Handler
ActiveWorkbook.FollowHyperlink Address:=wLink, NewWindow:=True
Unload Me
Exit Sub
err_Handler:
MsgBox "Cannot connect to " & wLink
End Sub
This code successfully opens Internet explorer, and opens the appropriate url.
But I want Mozilla to be the web browser.
View 6 Replies
View Related
Apr 22, 2014
I have an Excel sheet with about 1,000 rows. Each row has an origin and destination column. Now I need a code that opens a specific website and goes to a specific tab and then search for the origin and destination fields queries. The code then takes each row and place them in the search query. The result from each row can result a valid connection between an origin and a destination OR no connection exists. So simply if connection is successful, the code simply returns "yes" otherwise "no".
I can open the website from Excel, but what I need to click on specific tab where I do my searches. One of the problems I am facing is that when I try to click on the tab I need I get the message that I must use Internet Explorer or Chrome or Mozilla. Although Excel uses Internet Explorer to open the website. I am not sure why this error.
Attached you will find the following:
1 - Few data rows that we need to run the loop on.
2 - A snapshot of the website that we need to input the data from the rows (FOLLOW LINK)
3 A snapshot to show you the tab ("Ocean Schedule") that we need to access after we open the main website in vba. (FOLLOW LINK)
View 3 Replies
View Related
Oct 12, 2011
I am using the below code to login to a website from Excel when I close a userform.
What I now need is a way to check if the website is already open to prevent the code from running and I also would like to navigate to another page on the website once its logged in. The web address of the other page is:
[URL]
Sub LogInToRoyalMail()
Const cURL = "http://www.XXXXX.co.uk/" 'Enter the web address here
Const cUsername = "XXXXXX" 'Enter your user name here
Const cPassword = "XXXXXX" 'Enter your Password here
[Code].....
View 1 Replies
View Related
Jul 17, 2012
is there any possibility to open the firefox browser and navigate it to a website via vba?
View 1 Replies
View Related
Nov 28, 2008
I am havng problems with the belwo macro code -
Range("G7").Select
Selection.Copy
Workbooks.Open Filename:= _
"Q:PublicPAYMENTS Q&RREPORTSSuspense Activity BUSINESS2008 - Suspense BUSINESS - Activity Reports2008 Avon.xls"
Application.CutCopyMode = False
ActiveWorkbook.Save
ActiveWindow.Close
End Sub
When i open the workbook it requires me to insert a password, i tried to type this but excel will not follow keystrokes, i then inserted the password in cell G7 which i then copy and paste, which you can see the copy at the beginning of the macro.
Is there a way where you can get it to insert the password so i can open the workbook in a macro.
What im trying to do is save 26 suspense spreadsheets by just clicking on a macro.
View 9 Replies
View Related
Jul 26, 2013
I'm trying to copy a list of addresses from a website and paste that into Excel. I'm having problems because Excel doesn't separate each address. The original website address list has clear separation of addresses (returns, tabs, etc). For example:
John Doe
111 Fox Street
Van Nuys, CA 91403 (See there's no separation between addresses)
Michael Smith
2759 Apple Street
Encino, CA 93727
This is the website where the address list comes from: [URL]....
View 14 Replies
View Related
Oct 5, 2007
I have a thousand names on a column, and I have a several worksheet tabs as locations, such as CA, AZ, TX, and NY.
All names goes to main worksheet, show like this
apitchford 10 100 123
bkishpaugh 9 211 123
blee 14 234 111
cbonny 21 125 412
I need to pull a specific name, example, name = blee, move that name with all data on that row into TX.
I will need to set as automatically, becuase the names add and delete on the main worksheet, and will auto update those tab worksheets. (make sense?)
I have tried INDEX and MATCH, but they keep putting one data in, not all data.
View 9 Replies
View Related
Jun 19, 2014
I am trying cut and paste a list into Excel, and have Excel separate the different fields for me. There are 12 lines per each entry on the list. I use Firefox as my browser, and when I cut and paste using Firefox into Excel, this is how it looks:
James H. Patel, MD
(space)
Pediatrician
(space)[code]....
I'm hoping for the final product to look like this:
Last Name----First Name----whether MD or DO----Street Address----City, State, Zip code----Zipcode(by itself)
View 6 Replies
View Related
May 30, 2014
I'm trying to paste data from a website. It's in the format:
abcd abc abcd abc
abc abcdef abc abc
The data is separated by SPACES. There is a different number of spaces between the data on each line (not sure if that matters)
When I paste it into excel, each line comes through as one cell. Is there a way to tell excel to recognize the spaces as new cells?
Figured it out. Data --> Text to columns
View 3 Replies
View Related
Jan 9, 2009
A little unrelated to excel as such but helpful to many of us I think. How to set a password to open/ view any folder or directory?
View 2 Replies
View Related
