how to read dta from a web page automatically?

[Khoshravan]

I want to write a program in Excel as follows:
Go to a web site (This web site could be open in IE6)
Read two numbers (value, hour)
Write them in Excel
Perform this task every 10 minutes automatically.
Is this possible?
Now I am performing this manually.
It will be great if I can perform this process automatically.


--
Rasoul Khoshravan Azar
Kobe University, Kobe, Japan

how to read dta from a web page automatically?

[NickHK]

Would a web query do it ?
Data>Get External Data>New Web Query.

NickHK

"Khoshravan" <khoshravan@discussions.microsoft.com> wrote in message
news:412F5B3D-75B9-4607-91D8-ED223C21FF1E@microsoft.com...
> I want to write a program in Excel as follows:
> Go to a web site (This web site could be open in IE6)
> Read two numbers (value, hour)
> Write them in Excel
> Perform this task every 10 minutes automatically.
> Is this possible?
> Now I am performing this manually.
> It will be great if I can perform this process automatically.
>
>
> --
> Rasoul Khoshravan Azar
> Kobe University, Kobe, Japan
>
> how to read dta from a web page automatically?

[Khoshravan]

Thanks for your reply.
It worked some how. Thanks, I didn't know about that command.
I have few questions.
1- Is it possible to make it automatic to perform the task every 10 minutes?
2- It asks for table name in the web page or to copy all the page.
I case of my page, there was no table name, so I have to copy whole page.
Is there any way to give an address in the page just to copy that part?
Thanks in Advance
--
Rasoul Khoshravan Azar
Kobe University, Kobe, Japan


"NickHK" wrote:

> Would a web query do it ?
> Data>Get External Data>New Web Query.
>
> NickHK
>
> "Khoshravan" <khoshravan@discussions.microsoft.com> wrote in message
> news:412F5B3D-75B9-4607-91D8-ED223C21FF1E@microsoft.com...
> > I want to write a program in Excel as follows:
> > Go to a web site (This web site could be open in IE6)
> > Read two numbers (value, hour)
> > Write them in Excel
> > Perform this task every 10 minutes automatically.
> > Is this possible?
> > Now I am performing this manually.
> > It will be great if I can perform this process automatically.
> >
> >
> > --
> > Rasoul Khoshravan Azar
> > Kobe University, Kobe, Japan
> >
> > how to read dta from a web page automatically?
>
>
>

[NickHK]

#1: Right click somewhere in the data returned>Data Range Properties.
Check the "Refresh every" box and set the box to 10.
Check the help for the .BackGroundRefresh property to see how it may
affect your code. You probably want it set to False.
#2: Not that I know of. Once you have the refresh data, find the
appropriate cell (same one(s) each time ??), then copy/paste/process the
value(s).

If you want/need more control over what is downloaded, you will need a more
complex method.

NickHK

"Khoshravan" <khoshravan@discussions.microsoft.com> wrote in message
news:AA14C358-610A-4D8E-906E-366D28215620@microsoft.com...
> Thanks for your reply.
> It worked some how. Thanks, I didn't know about that command.
> I have few questions.
> 1- Is it possible to make it automatic to perform the task every 10
minutes?
> 2- It asks for table name in the web page or to copy all the page.
> I case of my page, there was no table name, so I have to copy whole page.
> Is there any way to give an address in the page just to copy that part?
> Thanks in Advance
> --
> Rasoul Khoshravan Azar
> Kobe University, Kobe, Japan
>
>
> "NickHK" wrote:
>
> > Would a web query do it ?
> > Data>Get External Data>New Web Query.
> >
> > NickHK
> >
> > "Khoshravan" <khoshravan@discussions.microsoft.com> wrote in message
> > news:412F5B3D-75B9-4607-91D8-ED223C21FF1E@microsoft.com...
> > > I want to write a program in Excel as follows:
> > > Go to a web site (This web site could be open in IE6)
> > > Read two numbers (value, hour)
> > > Write them in Excel
> > > Perform this task every 10 minutes automatically.
> > > Is this possible?
> > > Now I am performing this manually.
> > > It will be great if I can perform this process automatically.
> > >
> > >
> > > --
> > > Rasoul Khoshravan Azar
> > > Kobe University, Kobe, Japan
> > >
> > > how to read dta from a web page automatically?
> >
> >
> >