Hyperlink Headache

[Fowler_ko]

I have a number of hyperlinks in a worksheet that we are using as
content page for various projects.

All the hyperlinks are links to documents i.e word, excel or pdf. Wha
I am trying to achieve is a macro that will download the documents tha
are on the Internet and store them locally on the users machine.

Have tried using the copyfile command but this only seems to work wit
files stored on local or network drives. But fails when using a fil
on the net.

I have been banging my head against the wall with this one and canno
find the answer anywhere. Any pointers would be greatly appreciated

 

[Tom Ogilvy]

ftp provides the commands for copying files over a network.

Perhaps you want to pursue that.