Hyperlink file help
 

Hello All,

I am needing some major help. I have a file with hyperlinks in column F
that link to a file on our server. I am needing to test to see if the file
exists and if it does, copy the file to a folder in my documents called
(CapturedFiles) and if it doesn't format the cell color to red. Can VBA do
this and if so how? I am very basic when it comes to VBA and any help would
be greatly appreciated.

Thanks in advance!!!
Aaron