Storing Username And Password Data In .txt File

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


ADVERTISEMENT

Username And Password Form - When File Is Saved By Any Users All Hidden Files Get Unhidden?

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

Username / Password At Login

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

VBA (IE Enter UserName And PassWord)

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

To Submit UserName & Password On IE

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

Web Query. Log On Username & Password

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

Handling Username And Password Window Using VBA?

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

Enter Username & Password On Web Page

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

Automate Username & Password Log In To Web Page

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

Call Password Username Before Cell Entry?

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

API To Retrieve A Webpage Needing Username And Password

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

Find Username Match And Pull All Data At Same Row W/username

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

Require Password To Open If Username Does Not Match A List

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

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 View Related

Create Username And Password To Login Into A Macro Enabled Workbook

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

Excel 2010 :: Userform As Login Form - VBA To Validate Username And Password

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

Storing MS Word File Inside Spreadsheet?

Mar 14, 2014

Our client uses an Excel spreadsheet that we provide to adjudicate/comment on our delivered products (primarily documents and reports). The spreadsheet has columns for:

DefectCode, SectionPage, Comment, FinalDisposition, FinalComment.

At the end of the process of client meetings and revisions, we must generate an MS Word-formatted report. I've written a macro to parse the comments and columns and generate a mostly-formatted Word document. What's missing are the corporate headers, footers, logos -- the standard template or basic document stuff that all of the details would fill in. For now, I auto-gen a Word document and merge it by hand into the corporate template.

So my question is: if I want to "include" a corporate Word template with the spreadsheet, can I bundle it with the workbook somehow or must it always remain a separate file?

My current thinking is that since a *.xlsm file is really a ZIP file underneath, could I store the Word template there where it would effectively be hidden from the user? Or what is the best way to bundle an extra file like this with my workbook app?

View 2 Replies View Related

Password Protection :: Asking For Password Of An Old Deleted File

May 27, 2009

When opening a new Excel file, it is asking me for a password to an old excel file that was password protected, which I have deleted from my computer. It is still asking for this password every time I open a new or existing file. When I hit cancel it lets me open the file.

View 11 Replies View Related

Check Username On File Start Up

Oct 28, 2009

i have a spreadsheet with the following worksheets:

"Data Entry" (sheet 1)
"Menu" (sheet 2)
"Username" (sheet 3)

In username the range a2:b5 contains the following:
a2= John b2=Write
a3=Scott b3=Readonly
where John or Scott are usernames in Environ("Username")

Is it possible to write a macro that does the following:
1. When the file is opened it looks at the network username and checks again the Username range in sheet3, if it is Write then the user can change cells in Data Entry and save the workbook, if Readonly then they can only view and not save, and if not there at all, then the worksheet closes.

2. When the file is opened write a log in a hidden sheet callled "Log" of the time opened and the username

3. Is it possible to do the same but making a copy of all cells changed ??

View 3 Replies View Related

Display Username In Message Box That Has A File Open

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

Excel 2013 :: VBA Function To Get Username Of Open File On Network?

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

Storing And Organizing Data

Jul 11, 2014

I'm setting up a type of form in excel where I have some validated drop down lists and I'm trying to use a macro that will, upon a button click, take the data from the drop down lists that are entered into the boxes, and organize them into a chart on a different sheet of the document. This would be the form with some drop down lists.

Juice Type
Apple

Juice Size
8 oz.

Juice Buyer
Ronald

I want to add it in to a table with every button click filling in a new row in a table like this,

Juice Type
Juice Size
Juice Buyer

Apple
8 oz.
Ronald

View 3 Replies View Related

DAO Query On Password Protected File: Could Not Decrypt File

Dec 9, 2006

I have an existing application that uses DAO sql queries to populate a form. It has always worked fine. Earlier this week, I password protected the spreadsheet. Now my DAO query fails. I get a run-time error '3161'. Could not decrypt file.

' Const stExtens As String = "Excel 8.0;HDR=Yes;"
Const stExtens As String = "Excel 8.0;HDR=Yes;PWD=money16;"

Private Sub Execute_Query(SQL)
'Instantiate the DAO objects.
strDb = ThisWorkbook.FullName
Set DAO_ws = DBEngine.Workspaces(0)
' code fails on the line below
Set DAO_db = DAO_ws.OpenDatabase(strDb, False, True, stExtens)
Set DAO_rs = DAO_db.OpenRecordset(SQL, dbOpenForwardOnly)
End Sub

View 3 Replies View Related

Log UserName Of User On Data Entry

Dec 2, 2006

I have a spreadsheet where for traceability purposes, I get some vba to enter elsewhere on the sheet, the date and time that data is entered into a cell. Is it possible to also somehow capture the name of the person entering the data. We are on a network, so the pc does "know" which user is logged in.

View 8 Replies View Related

How To Put Password For Excel File?

Feb 16, 2010

I searched the forumn but didn't find thread sorry for creating new thread.

frends i have 2 questions.

1) How to put password for excel file (2003) ? (not for sheet)

2) How to remove password from excel file ? (if its not break forum rule).

View 3 Replies View Related

2 Password For One Excel File

Apr 17, 2014

Is it possible for Excel file to be open with 2 password? Like, if password is equal to "Password1" the file can be edited but if password is equal to "Password2" the file will be open as read only, if so, VBA code.

View 1 Replies View Related

VB- Open File With KNOWN Password

Oct 22, 2009

I have a macro that opens Spreadsheet_A, copies the contents to Spreadsheet_Master, closes Spreadsheet_A, then repeats the process for Spreadsheet_B then ss_C then ss_D etc etc etc.....

Each spreadsheet is password protected, and the password is the same for all spreadsheet to stop casual browsing only. I have set the password.

When I run the macro, I have to type the password in each instance, ie 20 or more times for 2 or more files.

Anyone know the code to insert so the spreadsheet opens without my typing the password.

[It's Excel 2007, but I presume the same code as Excel 2003]

View 9 Replies View Related

Save File Only Through Password

Aug 2, 2007

I tried to research this as much as I could, the thread below is a start but doesnt appear to be close...my request is a bit of a variant to this. I essentially need code that prevents someone from saving the file unless they have the right password.

View 6 Replies View Related

Unable To Open XLS File Without Password?

Feb 5, 2013

I have a certain .xls file which is password protected.

Now i have forgot the password for opening the file. Is there any other way of opening the file without password or using a Macro.

View 2 Replies View Related

Removing A Password From A Corrupt File?

Sep 30, 2013

Is there anyway I can remove the password from a corrupt file that I cant access so that I can use Stellar Pheonix Excel Recovery to repair it?

View 8 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved