Web Queries
 

Hi,

I'm working on compiling a list of information into a spreadsheet queried
from the internet. Now I click each arrow for the tables i want to import,
but instead of giving me that particular field, it gives me the one above it.
Sometimes it skips fields that I have checked and only imports some. It's
almost like it is picking which ones to import from the ones I have checked.
I don't know if others have experienced this problem or how one can solve
this. Any help is appreciated.

Thanks in advance.

Web Queries
 

No. I have not experienced such situation yet..

I frequently import portion of Cricket Scored card, as refreshable web
query in to my Microsoft Excel sheet, which is intended to refresh by itself,
with a specified time period.

Challa Prabhu


"Stonewall" wrote:

Hi,

I'm working on compiling a list of information into a spreadsheet queried
from the internet. Now I click each arrow for the tables i want to import,
but instead of giving me that particular field, it gives me the one above it.
Sometimes it skips fields that I have checked and only imports some. It's
almost like it is picking which ones to import from the ones I have checked.
I don't know if others have experienced this problem or how one can solve
this. Any help is appreciated.

Thanks in advance.

Web Queries
 

Supply example url and detailed instructions.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Stonewall" wrote in message
...
Hi,

I'm working on compiling a list of information into a spreadsheet queried
from the internet. Now I click each arrow for the tables i want to
import,
but instead of giving me that particular field, it gives me the one above
it.
Sometimes it skips fields that I have checked and only imports some. It's
almost like it is picking which ones to import from the ones I have
checked.
I don't know if others have experienced this problem or how one can solve
this. Any help is appreciated.

Thanks in advance.

Web Queries
 

Just for arguments sake, lets say the url is :
https://flagship.vanguard.com/VGApp/...rC hart=false

I opened a new Excel spreadsheet workbook and went to Data on the menu and
€œselected import external data€� from the drop down menu. I then selected
€œNew Web Query€� and navigated to the above website. I followed the
instructions and clicked the arrows next to the boxes I wanted to import
after which the arrows turned to check marks. I then clicked import and then
had this problem.

Thanks.


"Don Guillett" wrote:

Supply example url and detailed instructions.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Stonewall" wrote in message
...
Hi,

I'm working on compiling a list of information into a spreadsheet queried
from the internet. Now I click each arrow for the tables i want to
import,
but instead of giving me that particular field, it gives me the one above
it.
Sometimes it skips fields that I have checked and only imports some. It's
almost like it is picking which ones to import from the ones I have
checked.
I don't know if others have experienced this problem or how one can solve
this. Any help is appreciated.

Thanks in advance.

Web Queries
 

The approach I took is to goto the web siteright click on the fieldimport
to excelthen
recorded a macro while doing
dataimport external queryedit queryselected ALLimported.
Now when you get the data you can extract the data elsewhere, as desired.
Send me your address, OFF list and I'll send you the simple workbook.
Of course, the url should be able to be manipulated.

Sub Macro1()'Should be cleaned up ie:
with activesheet.querytables(1)
vs with selection.querytable

'
' Macro1 Macro
' Macro recorded 7/23/2007 by Donald B. Guillett
'

'
With Selection.QueryTable
.Connection = _
"URL;https://flagship.vanguard.com/VGApp/hnw/funds/performance?FundId=0040&FundIntExt=INT&DisplayBarC hart=false"
.WebSelectionType = xlEntirePage
.WebFormatting = xlWebFormattingRTF
.WebPreFormattedTextToColumns = True
.WebConsecutiveDelimitersAsOne = True
.WebSingleBlockTextImport = False
.WebDisableDateRecognition = False
.WebDisableRedirections = False
.Refresh BackgroundQuery:=False
End With
End Sub

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Stonewall" wrote in message
...
Just for arguments sake, lets say the url is :
https://flagship.vanguard.com/VGApp/...rC hart=false

I opened a new Excel spreadsheet workbook and went to Data on the menu and
€œselected import external data€� from the drop down menu. I then selected
€œNew Web Query€� and navigated to the above website. I followed the
instructions and clicked the arrows next to the boxes I wanted to import
after which the arrows turned to check marks. I then clicked import and
then
had this problem.

Thanks.


"Don Guillett" wrote:

Supply example url and detailed instructions.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Stonewall" wrote in message
...
Hi,

I'm working on compiling a list of information into a spreadsheet
queried
from the internet. Now I click each arrow for the tables i want to
import,
but instead of giving me that particular field, it gives me the one
above
it.
Sometimes it skips fields that I have checked and only imports some.
It's
almost like it is picking which ones to import from the ones I have
checked.
I don't know if others have experienced this problem or how one can
solve
this. Any help is appreciated.

Thanks in advance.