![]() |
|
#1
|
||||
|
||||
![]() Quote:
When I manually try to perform a Web Query, the unrequested data is still imported. 1. Create an .xls file. 2. Place the cursor at cell A1. 3. Select Data > Import External Data > New Web Query... 4. Address: http://www.worldcommunitygrid.org/te...rdsPerPage=100 5. Click on Arrow associated with Member Name. 6. Click on Import button. 7. Click on OK button. The following is imported: _____________________________ Download Software Do you want to download the software again? Click here to visit the Download page. Visit the Forums If you need technical assistance beyond what's available in Help, please visit the forums to post your questions and get answers on how others are using World Community Grid. Tell A Friend Help accelerate humanitarian research even further by telling your friends about World Community Grid. Related Resources System Requirements Points System Member Policy Powered by IBM _____________________________ This is NOT what was selected for import. Rather the site is defined as secure or not the same data is imported. If the manual technique is flawed, the macro will also be flawed. Also, I believe a shortcut key is needed to run the macro, but on this point I am not real sure, since I didn't get that far in my trial run. Last edited by Gandalf; 02-07-2013 at 11:06 AM. Reason: Fix typo |
![]() |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
How to Query Text in MS-Excel 2010 or Import Data & Query outside of Excel? | mag | Excel | 0 | 10-18-2012 11:15 AM |
Import excel data in to SQL Server | DavidBrown | Excel | 0 | 08-08-2011 04:49 AM |
How to Import Notes Field data along with attachments? | Prabhakar | Project | 0 | 04-08-2011 04:46 AM |
Import Pics and Excel Data into PP? | jawillyams | PowerPoint | 0 | 03-13-2011 01:03 PM |
![]() |
Cunner | Outlook | 2 | 08-20-2010 02:03 AM |