| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
name of file folder
how do you get the name of the file folder that your excel file is in?
|
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
name of file folder
If the opened files are saved
Thisworkbook.Path 'will return the path of the current workbook(where the macro is placed) Activeworkbook.Path 'will retun the path of active workbook If this post helps click Yes --------------- Jacob Skaria "dstiefe" wrote: how do you get the name of the file folder that your excel file is in? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Check for file in folder, if not there, open folder to rename file | Excel Programming | |||
| VBA can't find file as it moves from folder to folder | Excel Programming | |||
| Save file in a new folder, but create folder only if folder doesn't already exist? | Excel Programming | |||
| Need code to save file to new folder, erase from old folder | Excel Discussion (Misc queries) | |||
| Create Folder and Text File in folder | Excel Programming | |||
Linear Mode
