Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Get external data in excel from site with multiple logins

Posted on 2011-10-27
7
Medium Priority
?
229 Views
Last Modified: 2012-05-12
Hi!
I'm using the Get External Data feature in excel 2007 to get data from a website. The website requires a login, but excel remembers my user and password. My problem is: I want to get the data from two different logins on the website, into two different sheets in my workbook. When I try to set it up, however, excel always uses the last login I used, and puts the same data into both worksheets. Can anyone help?
0
Comment
Question by:etech0
  • 4
  • 2
7 Comments
 

Expert Comment

by:matttclark
ID: 37042550
maybe....what O/S version are you using with 2007?
0
 
LVL 10

Author Comment

by:etech0
ID: 37042666
XP
0
 
LVL 10

Author Comment

by:etech0
ID: 37094241
Anyone out there???
0
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 
LVL 26

Accepted Solution

by:
redmondb earned 2000 total points
ID: 37168631
Hi, etech0.

Let me immediately say that this is not an area I have any experience with, so apologies if I'm wasting your time.

After a bit of digging, I came across this link which looks interesting - the code requires a userid and password each time it runs (by deleting the site's cookies each time it's run).

HTH,
Brian.

0
 
LVL 10

Author Comment

by:etech0
ID: 37168837
Thanks for answering. Will look at the link now.
0
 
LVL 10

Author Closing Comment

by:etech0
ID: 37215872
Thanks!
0
 
LVL 26

Expert Comment

by:redmondb
ID: 37216036
Thanks, etecho. Did you have much tweaking to do to make it work?
0

Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
This article describes how you can use Custom Document Properties to store settings and other information in your workbook so that they will be available the next time you open the workbook.
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…

810 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question