Hyperlink File Help
 

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? Any help would be greatly appreciated.

Thanks in advance.

Hyperlink File Help
 

Fileserver or webserver ?

Tim

On Nov 23, 7:20*am, Aaron wrote:
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? *Any help would be greatly appreciated.

Thanks in advance.