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

It would probably be best if when a new trail is created all th
associated files are saved in the same folder, preferabley with today
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

--
cereldin
-----------------------------------------------------------------------
cereldine's Profile: http://www.excelforum.com/member.php...fo&userid=3206
View this thread: http://www.excelforum.com/showthread.php?threadid=54115