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!