| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Current Directory
I am writing a Macro that does some stuff then saves the file as "NAME.txt"
but the directory that I am will change with each new file. How do I grab the directory of the active workbook? I can grab the full file path (ActiveWorkbook.FullName) but I can not convert this to the directory. Any help? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2k3 query path to current directory | Excel Discussion (Misc queries) | |||
| Saving to "open" directory | New Users to Excel | |||
| Staying it its own directory. | Excel Worksheet Functions | |||
| Update Links to current Directory?? | Excel Discussion (Misc queries) | |||
| Extracting data from the current date | Excel Worksheet Functions | |||
Threaded Mode
