thomaspatton
03-14-2008, 02:20 PM
I've been playing around with a couple options I've seen in other places but I can't seem to get any of them to work right. I am trying in my Workbook_BeforeSave event to check the workbook name (WkBk v3.27) and if it's named the original file, name it "AMO-"& .Range.value.
I get the filename to save if it's just saving on my computer, however, I need to save the file to a different directory on an external(mobile) harddrive. Unfortunately, since everyone computer is different, I can't use Drive letter E: as a constant in the filepath.
How can I find the drive letter that the open file came from so I can save the open file as a different name under the same drive letter/different folder?
I get the filename to save if it's just saving on my computer, however, I need to save the file to a different directory on an external(mobile) harddrive. Unfortunately, since everyone computer is different, I can't use Drive letter E: as a constant in the filepath.
How can I find the drive letter that the open file came from so I can save the open file as a different name under the same drive letter/different folder?