Thread
:
Getting Table data from HTML page
View Single Post
#
11
Posted to microsoft.public.excel.programming,microsoft.public.office.developer.vba
Don Guillett[_4_]
external usenet poster
Posts: 2,337
Getting Table data from HTML page
Private workbook being sent that uses an imported query table with refresh
and this macro
Sub refreshtable()
Worksheets("Sheet1").QueryTables(1).Refresh _
BackgroundQuery:=False
Columns("f").ColumnWidth = 8
Cells(21, "f").Resize(5, 1).WrapText = False
End Sub
--
Don Guillett
SalesAid Software
"Mustafa Ahmad Malik" wrote in message
...
Here is the URL from where the data is to get
http://web.fldoe.org/NCLB/report.cfm...ol&district=31
Here how the output Excel layout should be
ColA ColB ColC ColD
ColE
ColF .....
--------------------------------------------------------------------------
--
-------------------------------------------
DistrictID SchoolID School grade Number of Students AYP Group Tested
95% of the students? 31% Reading at or above grade level? 38% scoring at
or
above grade level in Math? Improved performance in Writing by 1%?
Increased
Graduation Rate3by 1%? Showed 10% improvement in Reading percent not above
grade level? Showed 10% improvement in Math percent not above grade level?
2003 Y/N 2003 Y/N 2003 Y/N 2002 2003 Y/N 2001 2002 Y/N 2002
2003
Y/N 2002 2003 Y/N
31 0031 C 1518 N Total4 97 Y 36 Y 57 Y 90 84 N 59 73 Y
64
64 44 43
31 0031 C 1518 N White 96 Y 45 Y 66 Y 93 88 N 62 76 Y
55
55 33 34
31 0031 C 1518 N Black 95 Y 11 N 30 N 82 75 N 41 62 Y
88
89 79 70
31 0031 C 1518 N Hispanic 95 Y 18 N 46 Y 81 67 N 67 67 N
85 82 70 54
31 0031 C 1518 N Asian
31 0031 C 1518 N Am. Ind.
31 0031 C 1518 N Econ. 95 Y 17 N 35 N 82 71 N 40 59 Y 82
83 67 65
31 0031 C 1518 N Disadv.
"Don Guillett" wrote in message
...
Can you give us the url and the data you want for a test.
--
Don Guillett
SalesAid Software
"Mustafa Ahmad Malik" wrote in message
...
and is there a way to get data from a particular cell of HTML table
and
put
it in Excel sheet cell
Mustafa
"Bob Phillips" wrote in message
...
So get it all, and delete the bits you don't want.
--
HTH
Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
"Mustafa Ahmad Malik" wrote in
message
...
Thanks for the input. I need to get a part of a table. Say, table
has
10
rows and 10 Col. I need 5x5 table starting from row 4 and col 3 of
the
original table.
Thanks
Mustafa
"Mustafa Ahmad Malik" wrote in
message
...
Hi,
I'm interested to collect table data from HTML page. Is it
possible
using
excel-vba. If yes, how this can be done.
Thanks,
Mustafa
Reply With Quote
Don Guillett[_4_]
View Public Profile
Find all posts by Don Guillett[_4_]