Re: How do I create a new folder using a macro
- From: JE McGimpsey <jemcgimpsey@xxxxxxxx>
- Date: Tue, 10 May 2005 21:07:18 -0600
Take a look at the MkDir method in VBA Help.
Const sPATH As String = "C:/Program Files/"
MkDir sPath & Range("A1").Value
In article <89E33261-010F-44D0-A9C2-D285F052B47E@xxxxxxxxxxxxx>,
rsabot <rsabot@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
> I need to create a new folder using a folder name in a given cell (ex: A1).
> Can I create a macro that will make the new folder (ex: c:/program files/A1)?
>
> thanks in advance
.
- Follow-Ups:
- i always use filesystemobject to do this,
- From: zhuge
- i always use filesystemobject to do this,
- References:
- How do I create a new folder using a macro
- From: rsabot
- How do I create a new folder using a macro
- Prev by Date: Re: Checking Options in UserForms Collection
- Next by Date: Re: Using VBA to Unlock Cells
- Previous by thread: How do I create a new folder using a macro
- Next by thread: i always use filesystemobject to do this,
- Index(es):
Relevant Pages
|
