Go with MkDir. It is simple and works.

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

"cereldine" wrote
in message ...

Hi, I've written a code that pulls raw data into a variety of different
workbooks, as this is happening i wuld also like to create an audit
trail which includes the original filename and todays date. I believe
that i can do this in some fashion already.

It would probably be best if when a new trail is created all the
associated files are saved in the same folder, preferabley with todays
date. What is the best way to create a new folder from vba,

I was thinking something along the lines of

string1 = workbook.fullname and format(date)

mkdir string1

But ive also heard about filesys.createfolder ?

Has anyone else been faced with a similar task?


--
cereldine
------------------------------------------------------------------------
cereldine's Profile:
http://www.excelforum.com/member.php...o&userid=32069
View this thread: http://www.excelforum.com/showthread...hreadid=541158