| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
New sub-folder in Excel using a formula
In an arbitrary cell, enter:
C:\brian and Select that cell. Then run: Sub stitute() v = Selection.Value MkDir v End Sub -- Gary''s Student - gsnu200742 "Brian Connolly" wrote: I would like to read a cell value then create a Windows folder using the value in the cell as the folder name |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how can i change my default working folder to a networked folder? | Excel Discussion (Misc queries) | |||
| How to decide folder-depth or How to select more folders/subfolders (folder-tree) ? | Excel Discussion (Misc queries) | |||
| Need code to save file to new folder, erase from old folder | Excel Discussion (Misc queries) | |||
| how can I specific a folder with wildcard criteria and excel will import all the correct files in that folder? | Excel Discussion (Misc queries) | |||
| "Save As" folder -- can I default this to the same folder as origi | Excel Discussion (Misc queries) | |||
Hybrid Mode
