Create a new folder
 

Hi

I have done a search but can't find a way of creating a new folde
"back ups" in the current directory, can anyone help?

Andre

--
ap
-----------------------------------------------------------------------
aph's Profile: http://www.excelforum.com/member.php...fo&userid=1717
View this thread: http://www.excelforum.com/showthread.php?threadid=47750

Create a new folder
 

Try MkDir

MkDir "back ups"

Or

MkDir CurDir & "\back ups"


--
Regards Ron de Bruin
http://www.rondebruin.nl


"aph" wrote in message ...

Hi

I have done a search but can't find a way of creating a new folder
"back ups" in the current directory, can anyone help?

Andrew


--
aph
------------------------------------------------------------------------
aph's Profile: http://www.excelforum.com/member.php...o&userid=17175
View this thread: http://www.excelforum.com/showthread...hreadid=477501

Create a new folder
 

I'm not sure if you mean what I think, but
try to open a directory, right-click in a space within that directory
select the option ; NEW
then FOLDER

and name it what you will. :confused:


--
ufo_pilot
------------------------------------------------------------------------
ufo_pilot's Profile: http://www.excelforum.com/member.php...o&userid=25972
View this thread: http://www.excelforum.com/showthread...hreadid=477501

Create a new folder
 

I think the OP is trying to create a folder in VBA code. If so,
something like:

ChDir "C:\Documents and Settings\My Documents\ExcelTips\backups"

should do what they need.

Good Luck.


--
swatsp0p


------------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101
View this thread: http://www.excelforum.com/showthread...hreadid=477501

Create a new folder
 

I think the OP is trying to create a folder in VBA code. If so
something like:

ChDir "C:\Documents and Settings\My Documents\ExcelTips\backups"

should do what they need.

Good Luck

--
swatsp0

-----------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...fo&userid=1510
View this thread: http://www.excelforum.com/showthread.php?threadid=47750

Create a new folder
 

ChDir???

swatsp0p wrote:

I think the OP is trying to create a folder in VBA code. If so,
something like:

ChDir "C:\Documents and Settings\My Documents\ExcelTips\backups"

should do what they need.

Good Luck.

--
swatsp0p

------------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101
View this thread: http://www.excelforum.com/showthread...hreadid=477501

--

Dave Peterson

Create a new folder
 

Dave Peterson Wrote:
ChDir???


Dave Peterson

brain f**t.... meant MkDir... sorry

Ron had the right answer so I didn't bother correcting it. Is it
Friday yet?


--
swatsp0p


------------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101
View this thread: http://www.excelforum.com/showthread...hreadid=477501