| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
add a folder to c:\ drive from cell A1 contents...
Hi all:
How do I write a VBA code in excel to add a folder on the c:\ from the contents in cell A1. For example, if cell A1 has Look, how could I write code that makes a folder on the c:\ drive that is c:\look. Any help is greatly appreciated. Cheers. ~Matt |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
add a folder to c:\ drive from cell A1 contents...
See also the VBA help for MkDir
MkDir "C:\" & Sheets("Sheet1").Range("A1").Value -- Regards Ron de Bruin http://www.rondebruin.nl wrote in message oups.com... Hi all: How do I write a VBA code in excel to add a folder on the c:\ from the contents in cell A1. For example, if cell A1 has Look, how could I write code that makes a folder on the c:\ drive that is c:\look. Any help is greatly appreciated. Cheers. ~Matt |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need to have cell C8 contain contents of Cell G(formula) | Excel Discussion (Misc queries) | |||
| Selectively Clearing cell contents | Excel Worksheet Functions | |||
| Returning Cell Value if someone deletes the contents of a cell | Excel Worksheet Functions | |||
| Conversion of Cell Contents into a Functional Worksheet name ? | Excel Worksheet Functions | |||
| Function syntax to compare cell contents | Excel Worksheet Functions | |||
Linear Mode
