Import Data From Site Requiring Password?

Oct 19, 2012

import data from a website that requires a login/password (no login page, it pops up in a separate window like when trying to log onto an FTP).

I've got the login/password, and it's a simple call to the page to import it, but each time it asks me to authenticate when connecting (get the "Windows Security" popup asking me to authenticate).

Even when I select "Remember my credentials", it doesn't seem to, and so every time I end up having to manually hit enter to get by it.

Is there any way to pass the login/password information via VBA, or to get the "remember my credentials" to stick?

View 1 Replies


Import Data From A Single Cell In A Table On A Site

Jul 19, 2013

We have a list of around 800 clients containing client id, name and e-mail and i need to add contract number. I can only get the contract number by accessing the admin (password-protected) using a URL that looks like this admin/index.php?client=id.


1. if i use the From Web option in excel's data tab, i get the entire table not just the needed cell
2. if i get the data using the above mentioned option, i can only do it from one client at a time

View 5 Replies View Related

Web Query - Import Just Specific Tables On Site?

Aug 17, 2013

I have a website (National Lacrosse League - 2013 Regular Season - Standings), that I want to pull information off and automatically into Excel.

I have been using web queries on other websites, and they have worked beautifully, however the tables that I want aren't recognised by the web query wizard (no yellow/black arrows). I can import the whole page through a query, however that's not really practical.

Is there a way I can import just specific tables on this site?? I'd like both the 'east' and 'west' tables.

View 8 Replies View Related

Sorting Data Into Type And Site Name?

Aug 13, 2014

I am trying to fine an easy way to sort the attached spread sheet. it is a down load from our supplier which has a lot af data that i am not interesed in the only ones i need are columns description (r) and units (o) and name (g).

I am wanting to split each waste i.e oil fitters, acid batteries etc and each site so that the total amount each site has returned can be tabled ,so that i can create graphs showing who has/ has not return their waste steams.

View 6 Replies View Related

Requiring A Value In A Cell

Dec 22, 2008

How can i write VBA code to require a value in a particular cell in an excel spreadsheet. Upon exiting if a certain cell does not have a value a message box would pop up stating that a value must be placed in cell a1 before exiting.

View 9 Replies View Related

Transfer Data To Web Form From Framed Site

Sep 6, 2006

The following code works great:

Sub send_to_UCC()
Dim upcCode
Dim myTextField As Object

[Code] .....

But when the following code for a different page, does not work.

Sub send_to_UCC2()
Dim upcCode
Dim myTextField As Object

[Code] .....

Everything is the same except the URL and the textbox name.

View 8 Replies View Related

Transfer Data To Web Form From Framed Site

Sep 6, 2006

The following code works great:

Sub send_to_UCC()
Dim upcCode
Dim myTextField As Object
upcCode = "0001234512345"
appIE.navigate ""
appIE.Visible = True
Do While appIE.busy
With appIE
Set myTextField = .Document.all.Item("queryByGtin_key")
myTextField.Value = upcCode
End With
Set myTextField = Nothing
End Sub...........................

Everything is the same except the URL and the textbox name.

View 6 Replies View Related

Web Query Stay Connected And Get Live Data From A Site?

May 7, 2009

Is there any way to have a web query stay connected and get live data from a site while still being able to use excel at the same time?

Basically the site has information that changes by the second and i need to keep a running record of it, and when it hits the variables needed i want to be able to trigger a set of code.

View 9 Replies View Related

Transfer Data To Separate Tables Based Two Variables (date And Site)

Oct 28, 2009

I have a spreadsheet where raw data is entered ("RAW_DATA") for each month it is collected. There are 7 questions that are tallied and each of those responses are transfered to a separate data table for analysis (7 individual tabs within the spreadsheet). I'm currently manually data entering the values from the raw data tab to the other seven tabs.

I would like to have VBA code that could transfer the data from one month ("RAW_DATA") onto the other 7 tabs based on the date and facility identified in the raw data tab. I have not attempted the VBA since I do not know where to start with searching on two variables.

View 2 Replies View Related

Excel 2007 :: Formula Length Requiring Binary Save?

Jan 1, 2013

I'm receiving this statement when trying to save:

"One or more formulas in this workbook are longer than the allowed limit of 8192 characters. To avoid the limitation, save the workbook in the Excel 2007 Binary workbook format."

The longest formula is 29 characters long. Even if I add the number of characters in every formula in the workbook, it only adds up to 1664.

View 3 Replies View Related

Automatically Selecting Dynamic Fields And Requiring Text Entry

Feb 24, 2007

I've got a software test plan that has test cases w/ individual pull-downs to select result states (All individually color-coded thanks to a macro). If any state is selected other than "Pass" or "Untested", a text entry feild appears two rows beneath the test case for additional notes and information regarding what behavior occurred when the test was done.

I need a way to a.) Automatically select this text field once any state other than "Pass" or "Untested" is selected in the pull-down, and b.) Require text entry in the field before the user can proceed to the next test case. (ideally w/ accompanying custom error message describing what information is required.)

I've pasted my macro code below: ...

View 9 Replies View Related

Upload To FTP Site Within VBA

Aug 24, 2006

I have the following code, saving created files to a local network. I need to change the save location to an FTP site (with username and password). Is this possible/How do I do this?

Sub Filter()
Dim name As Object
Application. ScreenUpdating = False
Application.DisplayAlerts = False
ActiveSheet. Unprotect Password:="letmein"

View 9 Replies View Related

Counting Materials Used On Site

Jan 7, 2013

I have a master workbook called "BoM count" which I would like to have capture all the materials used on site. This info has already been captured on the workbook "Survey of materials used on site" (There are losts of these, 1 per site)

I want to open the survey within the BoM count workbook and pull out the relivant numbers of materials used and also list the site ID to show that, that survey has been completed.

View 1 Replies View Related

Connecting Between VBA Excel And Web Site

Dec 7, 2009

I have a some problem with connecting between VBA Excel and web site.

I wrote a macro to insert the data from excel but there is one problem with displaying the correct view.

I use this site to get the price of the bonds:

it is the site of russian exchange

First of all I write the ISIN code, for example RU000A0E6X12, in the "Quote Search" field and then press Enter for getting the data. After it I can choose the History information or Online from the last field in the left margin. I want to chose "History" and after it the dates from and till are appearing automatically. The automatization of it is my task. And I have only one problem in the end.

The program:

View 9 Replies View Related

Checking File From FTP Site

Mar 15, 2012

I have tried to search these forms for some information on how to have VBA code check a file saved in an FTP site. I am hoping to use this file to contain version information where the workbook code will compare the version of the workbook to the version log saved in a text file on an FTP server. If they are different, I would like a pop up window to appear that notifies the user that there is a new file available, and perhaps a prompt to save that new file to the user's computer (it does not need to update and replace current workbook).

Is it possible to have VBA check an FTP site for this if I put the username and password in the code?

View 1 Replies View Related

Count Days Not At Site

May 8, 2014

I have the vacation sheet so I can track my vacation hours used and available. The last thing I need is a way to count the number of days I'm not at my site. It doesn't matter why (Training, Holiday, Travel or Vacation) I need to track total days of site.

View 4 Replies View Related

Hits An External Site

Dec 18, 2006

I am working on a spreadsheet that hits an external site. My questions is, I need to hit the site about 80 times becuase I search for different info. It there a way to get the vba to go down a list 80 of names rather than me entering the vba code 80 times with the different names?

View 9 Replies View Related

Open A File On An FTP Site

Feb 11, 2009

Is it possible to open a file on an FTP site using VBA?

I've tried using the code below but it asks for a username and password even though it is in the code.

Workbooks.OpenText Filename:="ftp://username:password@ipaddress/ste1.txt", Origin:=xlWindows, StartRow:=1, DataType:=xlFixedWidth, FieldInfo:=Array(0, 1)

View 9 Replies View Related

List Of Web Site Queries

Apr 7, 2009

i have 306 web pages listed in sheet 1, A1:A306

how can i get a macro to open each and scrape a piece of info from each, and then store in a row in sheet 2?

View 9 Replies View Related

Calculating How Many Cars On Site

Mar 2, 2010

I am trying to create a spreadsheet to record the amount of cars in a car park at any one time.

I have created a basic sheet with columns for car/reg/visiting and a drop down box for time in and time out (both done using validation lists) and a duration column that calculates the time between in and out.

What I am looking to do is create something that tells me how many cars are onsite at any one time, taking into consideration what time cars come and go.

Then from this I am looking to produce a chart with axis of to time/cars.

View 9 Replies View Related

Macro: Log On To Secure Site

Oct 30, 2006

I've created a VBA-Form to import csv files into a spreadsheet.
Problem is IT have moved them to a secure server, and i've been given FTP Access to this server: \

I have a module which can locate a folder and count how many csv files are in that directory. Problem is if i put in the ftp address it doesnt connect because i need to login via the RUN window, by putting the FTp address then entering my userID and password.

Is there anyway i can bring up this dialog box without using the RUN window. i've attached a spreadsheet with a screen dump of the dialog box

View 9 Replies View Related

Vlookup To Read A Score For A Site

Jan 19, 2009

I am using a vlookup formula to a series of data sets. I am trying to get something so that it will display the relevant score for that site. However the lists are not the same size, how do i get a vlookup to read a score for a site if it is the the array but display "0" if the site name is not in the array?

It is coming up with #N/A and I can't do anything with that.

View 8 Replies View Related

Excel 2007 :: Import Data From Worksheet Into Another And Group Data Into Sections

Mar 2, 2012

I want to be able to run a macro that will export some of the data from a worksheet called Generated Report into another worksheet called Matrix. The data will be taken Generated REport and grouped into sections of the worksheet. These sections will be defined by the BRID value.

The Data that i want to export will be from the first 5 columns within the Generated Report(note there are other columns which data is not required from).

The following columns will be exported from Generated Report -

BRID,Requirement, Bug Description, Bug ID and Alt Bug ID.

BRIDRequirement Bug DescriptionBUG ID Alt Bug ID
PQ115 PQ115-Login Bug Description text xihllloloj43712 123
PQ116PQ116-Landing Bug Description text ghghghgoot 43713 126

For Matrix

The data will be imported into Matrix worksheet into the following columns as part of the row headings

- Requirement, Description, Bug ID and VF Bug ID.There will also be other columns (outlined below) which i will use to manually enter data

The data will be grouped and imported into the relevant section by its BRID eg PQ115, PQ116 etc.

I want each section (marked by BRID number)to be separated by row headings.

These row headings are to be generated after populating all data within each BRID number.

When the data has been populated in each row there is a column called 'Status' which contains drop down list boxes which can be assigned.

The default status will be set to 'To Do'. The complete row headings are displayed with Output from Generated Report underneath

BRID Priority Requirment Description BugID Alt Bug ID PC UpdateNotes Actual Result Type of DEfect Test Status Tested by
PQ115 PQ115-Login Bug Description text xihllloloj43712 123 To Do

BRID Priority Requirment Description BugID Alt Bug ID QC UpdateNotes Actual Result Type of DEfect Test Status Tested by
PQ116 PQ116-Landing Bug Description text ghghghgoot43713 126 To Do

So far the macro that i have been using allows me to locate the data for each specific BRID in Generated Report and copy into the corresponding BRID section within the Matrix. I have to repeat this step for each new BRID and i want to be able to whole automate this process.

View 5 Replies View Related

Date Format- Data Retrieved Via Import Data Tools

Feb 4, 2009

I have the following data retrieved via import data tools ...

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

Forgotten Password For Password Protected Sheet

Mar 21, 2007

I have a spreadsheet, which has certain worksheets that are password protected. I need to make changes to some of the formulas, and the VBA modules, however I cannot remember the password!! Is there a way of identifying the password??

View 3 Replies View Related

Sum Quantity And Show Total For Each Site In A Table?

Aug 15, 2014

I've attached a sample workbook. Data Table 2 on the Data Tables sheet is what I'm after. Basically I have a formula that sums up quantity 1 (Q1) and quantity 2 (Q2) for all widgets at a site name and month. So for example, go down through column site name and column month and add up all of Q1 for site1 in the month of Jun 2014 (all widgets). This works but it shows duplicate totals which makes sense as there are mutliple widget types at each site. I think the example workbook explains it better. Note the Pivot Table sheet is an example of what I'm showing currently and what I'd like to show. While I understand that depending on how I set up the Pivot Table I can get similar results using either Table 1 or Table 2 but the other thing is that my users like to do some filtering of the data sheet itself without regard to the Pivot Tables.

sum quantity and show total for each site.xlsx

View 3 Replies View Related

Automatic Updating Web Site Status In Cell

May 6, 2007

Cell A1 value is: B1 Value should automatically show "Possible"
Cell A1 value is: B1 Value should automatically show "Possible"
Cell A1 value is: www.jigarparekh.html B1 Value should automatically show "notvalid"

I need a formula which can automatically see the status of the website address and updated in B column. which means that one dose not need to go to the website page to see if it is correct or not.

I have lot of website in the one sheet and i don't want to go all this website and check if they are correct. I want the status of this website in b column once when i have the website name already in the A column.

View 9 Replies View Related

Import Few Data From Table To Another Sheet By Date Data?

Jan 22, 2014

i attach the file so you can look after you read

i have soccer table 1 sheet is "teams" which is the table of the league. 1 sheet is "games" which is the table of games of the league the last sheet called "import by date". in the end of every game day i sent email with the results of current day. for now im copy and pate all results and its not that easy and convenient. i want to make some formula that when i click in import data sheet the date its shows me all the results from that date. i try to do it with pivot table but didnt like how it displayd

View 2 Replies View Related

Import Website Data Into Excel (Scrapping Of Data)

Jun 20, 2014

I have a tedious task of copy/paste from our website. have a look at below sample data. I have around 1500 rows of data like this.



Column A has input data which i need to copy and paste in a web form. Column B will have results scrapped form webpage[ URL]. This webpage will need login details

If a code can be written which take value form column A of spreadsheet and paste in webpage like shown in above image and hit search button. Next webpage will be loaded with number of results like shown in below. Take the number of results and paste in column B of spreadsheet.

View 1 Replies View Related

Copyrights 2005-15, All rights reserved