Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-07-2013, 11:05 AM
Gandalf's Avatar
Gandalf Gandalf is offline Data query import Windows 7 64bit Data query import Office 2003
Novice
Data query import
 
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
Reply



Similar Threads
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
Data query import Outlook data import Cunner Outlook 2 08-20-2010 02:03 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:18 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft