View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
TUNGANA KURMA RAJU TUNGANA KURMA RAJU is offline
external usenet poster
 
Posts: 171
Default macro to download a csv file

I want to download a csv file(one sheet file) into my excel w/book as a one
of my w/sheet.Is there any macro that do the task.This is a dialy activity I
am doing.Launching IE,browsing the website for related links,finding the
downloaded file,downloading,saving in my documents,extrating from zip
folder,moving the page to w/book,renaming the w/sheet(before renaming
deleting the yesterday's sheet).
The macro should work on w/book open event with time criteria(say everyday
10PM)