Downloading page format from net

[johnbest]

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...!!!!!

Please guide me how to do this....

Thanks in advance
Johnbest

 

[Don Guillett]

This is done using an external web query. Depending on your excel version
(should always state) use Data>import external data>new query>etc.

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.

 

[johnbest]

dear Don Guillett

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


thanks in advance
johnbest

 

[Don Guillett]

You would need to send to my private email shown here