Logo 
Search:

MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

HOW TO LINK EXCEL TO INTERNET

  Asked By: Molly    Date: Feb 27    Category: MS Office    Views: 3222
  

CAN ANYBODY ANS TO MY QUERY...

EVERYDAY I HAVE TO MAKE CERTIFICATES OF FOREIGN RREMITTANCE FOR THAT I
HAVE TO CONVERT CURRENCY (SAY $)IN INR .FOR THIS EVERY DAY I HAVE TO
GO TO SITE AND GET EXCHANGE RATE ON THAT DAY AND THEN IT IS TO BE
ENTER IN EXCEL,WHAT I WANT IS CAN WE LINK THAT SITE DIRECTLU TO EXCEL
FILE SO THAT ON JUST 1 CLICK IN FILE IT WILL GIVE ME PRESENT EXCHANGE
RATE FROM SITE.

Share: 

 

3 Answers Found

 
Answer #1    Answered By: Rochelle Elliott     Answered On: Feb 27

I have done a little bit of programming to interphase with Excel and
Internet Explorer. I can give  you a start off on how to connect and read
I hope this will help you to carry on your further investigation.

Dim ie as Object

'Create an object to Internet Explorer
Set ie = CreateObject("InternetExplorer.Application")

path1 = "http://www.google.co.in/ <http://www.google.co.in/> "

ie.Visible = False
ie.Navigate (path1)

'Wait till explorer navigate's to the page
While (ie.Busy = True)
Wend

'All the text on the current window will be assigned to strdata variable
strdata = ie.Document.body.innertext

You can search for the data you are looking for from this strdata
variable. Hope this helps :)

 
Answer #2    Answered By: Silvia Chapman     Answered On: Feb 27

well i'm not sure exactly what is wanted here.. but excel  (2003 at least) has
the capability of querying a web site/table you should be able to connect to the
website select the table you want and excel will import the data, i believe
it'll link  to the data so it will change.. if you record the macro of the steps
then you can rerun it at your leisure

 
Answer #3    Answered By: Ty Thompson     Answered On: Feb 27

Very elegant solution. It has sparked off some ideas for something I was
planning to do, and now it has suddenly become much easier.

 
Didn't find what you were looking for? Find more on HOW TO LINK EXCEL TO INTERNET Or get search suggestion and latest updates.




Tagged: