File Location Based on Cell Reference
I have a worksheet cell (say a1) with values such as Paul, David, Mark etc.
What I am struggling with is to develop a macro which will use the data in
that cell to determine the location the file will be saved to when the macro
is run.
i.e If a1= Paul, the file location will be F:/Paul's Directory/Filename.xls
If a1 = Mark, the file location will be F:/Mark's Directory/Filename.xls
Any suggestions would be appreciated.
|