July 5, 2009 05:29pm pdt

1. jason1178 88,823
2. Ray_Pas... 68,390
3. shalomc 64,175
4. mplungjan 52,520
5. selvol 50,075
6. Kravimir 48,795
7. abel 47,300
8. carrzkiss 40,922
9. HonorGod 33,780
10. Graphixer 32,757
11. logudotcom 28,670
12. gawai 27,800
13. cxr 23,850
14. renazonse 22,540
15. gwkg 22,380
16. alien109 20,790
17. b0lsc0tt 19,985
18. v2Media 19,464
19. caterham... 19,440
20. objects 19,380
21. ericpete 18,900
22. hielo 17,200
23. fsze88 16,980
24. myderrick 16,475
25. Hube02 16,268

1. rdivilbiss 785,964
2. COBOLdi... 505,389
3. b0lsc0tt 429,803
4. OliWarner 422,264
5. LeeKowal... 373,805
6. amit_g 360,877
7. jason1178 350,661
8. PraxisWeb 313,539
9. cheekycj 284,037
10. shalomc 265,674
11. mrichmon 256,287
12. julianmatz 248,426
13. humeniuk 240,131
14. hielo 236,079
15. Roonaan 224,390
16. webwoman 204,862
17. mplungjan 200,269
18. mrcoffee... 188,468
19. avidya 185,643
20. Zyloch 170,522
21. rsdn 167,615
22. sajuks 165,692
23. pinaldave 161,935
24. callrs 160,467
25. dorward 157,194

	[x] Posted via EE Mobile
	Search, ask, and monitor your questions on the go with EE Mobile. Visit Experts Exchange from your mobile device and never be out of touch again.

10/20/2003 at 12:16AM PDT, ID: 20771671

	[x] Attachment Details

[x]

The Solution Rating System

With so many solutions, how can you tell which solutions are most likely to help you and which ones are not? To provide you with a tool to use, we rate our solutions based on various elements that most accurately determine if a solution is a quality solution. To explain what factors affect the solution rating, here are the elements we take into consideration when formulating our solution rating.

The Grade of the Solution
The Zone Rank of the Expert Providing the Solution
The Number of Author and Expert Comments
The Number of Experts Contributing
The Feedback of the Community

Your Input Matters
Because of the way the system is set up, the most important variable in this equation is you. As a member of Experts Exchange, you are able to cast your vote on the quality of the solutions in regard to how complete, accurate, helpful and easy to understand each solution is. When you provide your feedback, each rating is adjusted accordingly. So, if you see a solution that has a poor rating that you think is a good solution, let us know by rating it. As you do, the rating will be adjusted and will become more accurate for other members of our site.

If you have any suggestions that you would like to make for our rating system, please ask a question in the Suggestions Zone of Community Support.

Thank you!

9.0

Dynamic Excel Web Query

Asked by rmission in Miscellaneous Web Development

Tags: excel, query, web, dynamic

I have a web application that displays personal data that is related to the user that is logged on to the application. In other words, when John logs on to the app, he will only see his personal data, and when Mary is logged on, she is able to see only her personal data. Other users' data is not accessible.

A SQL Server db provides the data for the web application. The application is very simple, the user is required to put in a valid username and password and on successful login, the user is able to use the web app to interogate the db (for relevant personal data).

Now, what I want to do is that from Excel, I want to create a new Web Query (Data|Import External Data|New Web Query). Selecting New Web Query brings up our local intranet page, on which a there is a link to my web application.

Clicking on this link (to the app) brings up a app's login screen. Putting in the correct account details bring up the first page of the web app. I then select a number of segments (mostly tables) from this page (by clicking the arrows to the left of each segment on the page, and then click on the Import button.

I now have the selected segments from my web app imported to my Excel spreadsheet (to a nominated cell) and then I save this excel file.

I then want to send this Excel file to another user who has access to my web application. What I want this Excel file to do is that on refreshing the data in it (Right-Click on worksheet then select Refersh Data) I want it to prompt the (other) user for a login/password and then automatically refresh the content of the Excel file with the data that belongs to the new user.

How can I do this?

Please note that I have never done this before and so I would appreciate a bit of clarity.

Thankyou.
View the Solution FREE for 7 Days

20090114-EE-VQP-51

Dynamic Excel Web Query

Asked by rmission in Miscellaneous Web Development

Tags: excel, query, web, dynamic

About this solution