View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Steve[_63_] Steve[_63_] is offline
external usenet poster
 
Posts: 13
Default auto download file everyday

Hi all,

can somebody stear me in the right direction.

I would like to download this file
http://nus800:8060/resources/thors/cni/CNI_Tool.xls into this folder
g:\everyone\thorsreports\ and schedule it to run automatically each
day, eg 9am with opening excel?

The file would replace the existing file each day, so that it's "up to
date"...

Can this be done with VBA?

Excel 97 WinNT, always online


TIA and cheers
steve