Blueridge227
New Member
- Joined
- Mar 23, 2011
- Messages
- 29
I am on a tight deadline and have searched high and low for VBA help on this, with no luck.
I have a column (E) of filenames.
2046.pdf
2057.pdf
2058.pdf ....etc
The pdf files with these filenames exist on my directory C:\Acrobat Files\
I need a Macro that will check if the files in Column E exist and mark the cell green if it does, Red if it doesn't.
An added bonus would be to create a hyperlink if the file exists as well. But not imperative.
Any help would be appreciated. Thank You!
I have a column (E) of filenames.
2046.pdf
2057.pdf
2058.pdf ....etc
The pdf files with these filenames exist on my directory C:\Acrobat Files\
I need a Macro that will check if the files in Column E exist and mark the cell green if it does, Red if it doesn't.
An added bonus would be to create a hyperlink if the file exists as well. But not imperative.
Any help would be appreciated. Thank You!
Last edited: