Reference: http://www.worldcommunitygrid.org/te...rdsPerPage=100
I'm looking for someone smarter than me. That's the easy part. I'm using Microsoft Excel 2003, because I can't afford the newer versions. I am trying to do a Data > Import External Data > from the referenced link.
The data field starts with Member Name. I am importing the data into an empty worksheet named WCG. At most, the worksheet will have yesterday's manually download of data in it.
Here is the catch. It doesn't work, automatically. I am trying to get the spreadsheet to import the daily updated data every time I open the .xls file. When I do get something to import it puts unwanted data into the beginning columns before the wanted data is brought in/imported. With this unwanted data being brought in, I can't check to see if the wanted data is being used correctly, because all the wanted data is columns to the right of where the other worksheets are looking for the data to be.
Until this is corrected, I can't really determine of the import is occurring correctly each time I open the file. I suppose I could adjust the programming on the other sheets to compensate for the right shift in the wanted data location on the worksheet, but that feels like cheating. Besides, I'd like to know why Excel in importing the unrequested columns of data.
Any and all assistance in solving this exasperating issue is much appreciated.
Gandalf
P.S. I can manually import the data successfully via copy and paste techniques.
It's the automatic technique that I am sorely failing at.
Bookmarks