Is there only ever one subdirectory under "H:\2006\" ?
What if there were two: (eg) 2006_SomeProjectName and 2006_SomeOtherProject ?
Could that ever happen ?
Tim
"Object" wrote in message
...
Hi,
Is there a way to save to a folder when only part of the folder name is
known?
The path i want to save it into
H:\2006\2006_SomeProjectName\transmittal.xls
2006 is stored in a variable ProjectYear and will always be know.
SomeProjectName will always be unknown.
So with the exceptioin of SomeProjectName (which i have shown as
question marks) the save path would look something like this.
ProjectPathXLS = "H:\" + ProjectYear + "\" + ProjectYear + ???? + "\
transmittal.xls"
Thanks for any help!
--
Object
------------------------------------------------------------------------
Object's Profile: http://www.excelforum.com/member.php...o&userid=33752
View this thread: http://www.excelforum.com/showthread...hreadid=537649