Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
aph aph is offline
external usenet poster
 
Posts: 1
Default 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

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11,123
Default 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



  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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.


--
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

  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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

  #5   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 35,218
Default 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


  #6   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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

  #7   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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

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
Create New Folder JMay Excel Programming 6 June 9th 04 02:14 PM
Create Folder and Text File in folder Todd Huttentsine Excel Programming 2 April 29th 04 03:41 PM
Create a Folder Murray Outtrim[_3_] Excel Programming 1 March 2nd 04 06:41 PM
Create Folder Murray Outtrim[_4_] Excel Programming 1 March 2nd 04 06:12 PM
Create Folder / Copy Folder / Replace Murray Outtrim[_2_] Excel Programming 0 February 24th 04 06:40 PM


All times are GMT +1. The time now is 12:25 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"