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
ADVERTISEMENT
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.
Problems:
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
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
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
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
Sep 6, 2006
The following code works great:
VB:
Sub send_to_UCC()
Dim upcCode
Dim myTextField As Object
[Code] .....
But when the following code for a different page, does not work.
VB:
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
Sep 6, 2006
The following code works great:
Sub send_to_UCC()
Dim upcCode
Dim myTextField As Object
upcCode = "0001234512345"
Set appIE = CreateObject("INTERNETEXPLORER.APPLICATION")
appIE.navigate "http://directory.gs1.org/gtin"
appIE.Visible = True
Do While appIE.busy
DoEvents
Loop
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
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
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
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
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
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"
MYCOUNTER = 100
View 9 Replies
View Related
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
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:
[url]
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
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
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
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
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
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
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
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: \00.0.00.0folderfolder.
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
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
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
Feb 4, 2009
I have the following data retrieved via import data tools ...
View 9 Replies
View Related
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
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
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
May 6, 2007
Cell A1 value is: www.yahoo.com B1 Value should automatically show "Possible"
Cell A1 value is: www.icallindia.net 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
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
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.
Sheet1
A
B
[Code]....
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