View Webpage

  • Thread starter Thread starter Murtaza
  • Start date Start date
M

Murtaza

How can i view a HTML page in Excel, it should also be automatically update
in 60 seconds. Is this possible?
Please note that, that page contains images

That webpage is on our intranet website.

Regards,
Murtaza
 
Though I am not certain this is exactly what you are looking for, try the
following:
Data, Import External Data, then New Web Query...
In the dialog box that appears, browse the site. You will notice that at
certain areas of the page you will see an arrow. Just click the ones that
you want to import. Click import. Select the cell you want to import the
data into and click OK.

Hope that helps.
 
Thanks Jamie:
It worked but only to get the text message / numbers. It could not import
images in the webpage.

anymore ideas!
 
Hi Jamie,
You can open the webpage from Excel, but it will be a representation
in Excel. Any formatting change in the webpage, even a minor change,
is going to change the Excel sheet and any macros addressing it.

You have a definite advantage since the entire process is within your
company and changes to formatting can be kept down. What is the purpose
of having an HTML page presented in Excel every 60 seconds?
If you want the data why not get it from the same source being used
to update the HTML page.

To automatically refresh the Excel page
you would want to use ONTIME (see Chip Pearson's pages).
 
Back
Top