Web Queries

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
Just for argument’s sake, let’s say the url is :
https://flagship.vanguard.com/VGApp...dId=0040&FundIntExt=INT&DisplayBarChart=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.
 
The approach I took is to goto the web site>right click on the field>import
to excel>then
recorded a macro while doing
data>import external query>edit query>selected ALL>imported.
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...dId=0040&FundIntExt=INT&DisplayBarChart=false"
.WebSelectionType = xlEntirePage
.WebFormatting = xlWebFormattingRTF
.WebPreFormattedTextToColumns = True
.WebConsecutiveDelimitersAsOne = True
.WebSingleBlockTextImport = False
.WebDisableDateRecognition = False
.WebDisableRedirections = False
.Refresh BackgroundQuery:=False
End With
End Sub
 
Back
Top