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.

--
Don Guillett
SalesAid Software
[email protected]
"johnbest" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>
>
> --
> johnbest
> ------------------------------------------------------------------------
> johnbest's Profile:
> http://www.excelforum.com/member.php...o&userid=29694
> View this thread: http://www.excelforum.com/showthread...hreadid=494118
>

[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

--
Don Guillett
SalesAid Software
[email protected]
"johnbest" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>