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

--
Fowler_k
-----------------------------------------------------------------------
Fowler_ko's Profile: http://www.excelforum.com/member.php...fo&userid=1647
View this thread: http://www.excelforum.com/showthread.php?threadid=27831

ftp provides the commands for copying files over a network.

Perhaps you want to pursue that.

--
Regards,
Tom Ogilvy

"Fowler_ko" wrote in message
...

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

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

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

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


--
Fowler_ko
------------------------------------------------------------------------
Fowler_ko's Profile:
http://www.excelforum.com/member.php...o&userid=16479
View this thread: http://www.excelforum.com/showthread...hreadid=278314