how to read dta from a web page automatically?
 

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?

how to read dta from a web page automatically?
 

Would a web query do it ?
DataGet External DataNew Web Query.

NickHK

"Khoshravan" wrote in message
...
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?

how to read dta from a web page automatically?
 

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 ?
DataGet External DataNew Web Query.

NickHK

"Khoshravan" wrote in message
...
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?

how to read dta from a web page automatically?
 

#1: Right click somewhere in the data returnedData 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" wrote in message
...
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 ?
DataGet External DataNew Web Query.

NickHK

"Khoshravan" wrote in message
...
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?