Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1,560
Default creating a new folder with a value of a cell on the C directory

This is what I've done
mkdir "C:\\ C3"

I want to take the value that I put in cell "C3", and by pressing a comand
button it create a folder on my hard drive like this

C:\"the value of cell C3"
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 10
Default creating a new folder with a value of a cell on the C director

How can I create five more folders after that

"Mike H" wrote:

Try this

MkDir "C:\" & Range("C3").Value


Mike

"David" wrote:

This is what I've done
mkdir "C:\\ C3"

I want to take the value that I put in cell "C3", and by pressing a comand
button it create a folder on my hard drive like this

C:\"the value of cell C3"

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
creating a new folder with a value of a cell on the C directory Mike H Excel Programming 0 November 11th 08 09:54 PM
Creating Directory Structure from Cell Value [email protected] Excel Worksheet Functions 5 December 7th 07 09:33 PM
Run macro from directory folder...? Clarissa Excel Programming 2 May 11th 07 06:17 AM
Creating a macro that lists directory names within a directory.... Andy Excel Programming 4 November 28th 04 06:13 AM
How to check if a folder/directory exist using VBA wellie Excel Programming 1 March 1st 04 02:24 AM


All times are GMT +1. The time now is 11:39 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"