Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to look for the Folder Path using macro????
Hi,
I would like to save some files in a particular folder, for example (Ven_Folder) in my computer system; but this folder may be transffered to another directory time after time. So instead of using the absolute path to fix the file saving location; I would pretty much wish that there could have a way the macro can help to lookup for the folder path before those mentioned files are saved. I have tried out the Dir statement but it can only work in the 1st loop in looping control structure. Thus, anyone can help in this matter.......???? Thanking in advanced. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Path and Number of files in a folder. - Pass to Macro. | Excel Discussion (Misc queries) | |||
How to List the names of the subfolders present in the folder (path of folder is given in the textbox by user ) | Excel Programming | |||
Setting a path to a folder | Excel Discussion (Misc queries) | |||
Get Folder Path | Excel Programming | |||
find if there is a particular folder in a path | Excel Programming |