Is there a way to find out which drive and directory a particular file is in. I would like to be able to do this through VBA. All I need is to be able to capture the drive letter and the folder that a particular file is in and save it.
Any Ideas.....?
Any Ideas.....?