Downloading page format from net
 

Hi friends

My first ever post....

I have a web page whose template is fixed. Every half hour the page
gets updated. There are 10 rows (say 10 Students in a class) and
9 cols ( say there subjects). Every half hour this web page gets
updated
and i want that data in one excel page. after getting the updated
data,
it should be transferred to other sheet (will be 10 say for each
student)
These respective sheets will have another column with date and time
data which will be taken from the web page......

A friend of mine told me this could be done in Excel but dont now how
to
do it...!!!!!:eek:

Please guide me how to do this....

Thanks in advance
Johnbest


--
johnbest
------------------------------------------------------------------------
johnbest's Profile: http://www.excelforum.com/member.php...o&userid=29694
View this thread: http://www.excelforum.com/showthread...hreadid=494118

Downloading page format from net
 

This is done using an external web query. Depending on your excel version
(should always state) use Dataimport external datanew queryetc.

or you may be able to just right click the table and select export to excel.
Sounds like you may need professional help from one of us.

--
Don Guillett
SalesAid Software

"johnbest" wrote in
message ...

Hi friends

My first ever post....

I have a web page whose template is fixed. Every half hour the page
gets updated. There are 10 rows (say 10 Students in a class) and
9 cols ( say there subjects). Every half hour this web page gets
updated
and i want that data in one excel page. after getting the updated
data,
it should be transferred to other sheet (will be 10 say for each
student)
These respective sheets will have another column with date and time
data which will be taken from the web page......

A friend of mine told me this could be done in Excel but dont now how
to
do it...!!!!!:eek:

Please guide me how to do this....

Thanks in advance
Johnbest


--
johnbest
------------------------------------------------------------------------
johnbest's Profile:
http://www.excelforum.com/member.php...o&userid=29694
View this thread: http://www.excelforum.com/showthread...hreadid=494118

Downloading page format from net
 

dear Don Guillett

yes i think so.....well are you ready to help me.
then start ....................


thanks in advance
johnbest


--
johnbest
------------------------------------------------------------------------
johnbest's Profile: http://www.excelforum.com/member.php...o&userid=29694
View this thread: http://www.excelforum.com/showthread...hreadid=494118

Downloading page format from net
 

You would need to send to my private email shown here

--
Don Guillett
SalesAid Software

"johnbest" wrote in
message ...

dear Don Guillett

yes i think so.....well are you ready to help me.
then start ....................


thanks in advance
johnbest


--
johnbest
------------------------------------------------------------------------
johnbest's Profile:
http://www.excelforum.com/member.php...o&userid=29694
View this thread: http://www.excelforum.com/showthread...hreadid=494118