| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Save file using part of folder name
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Save file to same directory folder | Excel Discussion (Misc queries) | |||
| in which folder can you save a .CSV file? | Excel Discussion (Misc queries) | |||
| Need code to save file to new folder, erase from old folder | Excel Discussion (Misc queries) | |||
| open file from folder save in new folder | Excel Programming | |||
| How do I save a read only file or folder? | Excel Discussion (Misc queries) | |||
Threaded Mode
