View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tim Williams[_4_] Tim Williams[_4_] is offline
external usenet poster
 
Posts: 114
Default 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.