Thread: [Solved] Data query import
View Single Post
 
Old 02-07-2013, 11:05 AM
Gandalf's Avatar
Gandalf Gandalf is offline Windows 7 64bit Office 2003
Novice
 
Join Date: Feb 2013
Location: California, USA
Posts: 9
Gandalf is on a distinguished road
Default

Quote:
Originally Posted by OTPM View Post
Hi
Now I understand what you are trying to achieve (I think ).
If you are trying to automate the import process then have you tried recording a macro whilst you do the manual process. You can then use the macro for future imports and make it automatic.
Is this what you want?
Tony
Tony,

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
Reply With Quote