View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Warzel Warzel is offline
external usenet poster
 
Posts: 11
Default importing info from a website using a macro function

M.Woodard wrote:
Is there a way to import info from a website using a macro function? and if
so, how is this process done.


You can open a web site like a file, just type in the URL

In a module you can do it like this
Workbooks.Open Filename:="http://www.the_website_of_intrest.com/"

You can then use additional macro's to extract the data you are
intrested in.