Login To HTTPS Server

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


ADVERTISEMENT

Embed Image In Cell :: HTTPS URL To An Image

Aug 8, 2006

I have a dataset that includes the path and optionally an HTTPS URL to an image. Is it possible to embed this image in a cell?

Short of that what might be some other options?

View 11 Replies View Related

Login Using VBA

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

Vba Login To Internet

May 13, 2008

how can I login to a website using vba. I googled many examples but still failed.

View 9 Replies View Related

Creating A Login Box

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

Login To Web Page Via Add-in

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

Macros On Server

Nov 5, 2008

I have a spreadsheet which I used in a previous job, which was set up by our old IT Department. Basically, it allows me to save information onto it, which I can then retrieve, (in any conditions/search fields i.e. in a date range etc) but the problem is; when I try to use it on my laptop, I look at the editor used for macros, I can see that the spreadsheet is linked to the servers of my old company. Therefore, I cannot use it myself

I do not know a lot about macros etc. but I can send a copy of the spreadsheet to anybody who is willing to help!

I think it is just a case of changing the macros/strings of where to draw and save information to/from, but I don;t know.

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

Creating Login Via A Userform?

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

Login To Website Using VBA Script

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

Create Login Screen

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

Drop-down List At Login

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

Using VBA To Complete Login Form

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

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

Login Option On Workbook

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

Code To Login To Webpage

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

Macro: Login To Web Query

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

Userform To Act As A Login With A Password

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

Retrieve Data From Sql Server

Nov 25, 2008

This code should retrieve data from sql server to excel sheet
filtering according to the "where" statement
its a modified recorded macro.

View 7 Replies View Related

Saving A File To The Server

Jul 31, 2006

I'm trying to open a file from server.After doing all the changes I have to save the file back to the server in the same name. It is asking for save as option.it shouldn't. I want to save the file in the same path and in same name without asking the option of "Save as". I hv full permission for editing the file

View 4 Replies View Related

Open File On FTP Server

Jun 13, 2008

I try to run a macro on my workbook everytime I open it by getting the data from the ftp file. This will be the service number for my customer. Both the excel and the data file are located in the ftp, so that I can retrieve the file wherever I go. Basically I got some code from the internet which work fine on the local network, but once it come to ftp server I am stuck there.

Public Function NextSeqNumber(Optional sFileName As String, Optional nSeqNumber As Long = -1) As Long
Const sDEFAULT_PATH As String = "Ftp://mycompany.com"
Const sDEFAULT_FNAME As String = "Service.txt"
Dim nFileNumber As Long
nFileNumber = FreeFile
If sFileName = "" Then sFileName = sDEFAULT_FNAME
If InStr(sFileName, Application.PathSeparator) = 0 Then _
sFileName = sDEFAULT_PATH & Application.PathSeparator & sFileName
If nSeqNumber = -1& Then
If Dir(sFileName) <> "" Then
Open sFileName For Input As nFileNumber
Input #nFileNumber, nSeqNumber..................

View 2 Replies View Related

Login Form - User Access

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

Code To Verify Password On Login

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

Get Data From Website That Requires Login

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

Get Excel To Login Automatically To Website

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

Getting Macro Program With Array Login

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

Creating A Login System For Users

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

Userform To Act As A Login With A Password To Use The Spreadsheet

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

Password Login To View Sheets

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

Server Uptime / Downtime Calculation

Apr 29, 2014

We have a number of internal office servers (Active Directory - Exchange - SharePoint "free" etc etc usual stuff) and I need to create an uptime/downtime calculator in excel with the facility to record the information on a daily, monthly and yearly bases but not sure how to go about this.

I would like a way to record on a daily bases what the uptime/downtime has been for each server and then to record the same for that month in a percentage.

For example in a 24hr period for each month of the year:

For that day Active Directory Server was UP for 24hrs. (100% uptime) - (0% downtime)
X by the number of days in the month i.e.
Over the month Active Directory has been UP for. (XX% uptime) - (XX% downtime)

Exchange Server was DOWN for 1hrs. (95.833% uptime) - (x% downtime)
X by the number of days in the month i.e.
Over the month Exchange has been UP for. (XX% uptime) - (XX% downtime)

SharePoint Server was DOWN for 1hrs. (95.833% uptime) - (x% downtime)
X by the number of days in the month i.e.
Over the month SharePoint has been UP for. (XX% uptime) - (XX% downtime)

View 5 Replies View Related







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