I am getting a syntax and compile error on the dim cou .... line. An
suggestions?
Thanks,
Jim
Sub createfolders()
'
'
dim cou as integer,Dim FolderStr as string, FileSys
For cou = 1 To ActiveSheet.UsedRange.Rows.Count
FolderStr = Format(Trim(Str(cou)), "00#") + "_"
ActiveSheet.Cells(cou, 1)
Set FileSys = CreateObject("Scripting.FileSystemObject")
FileSys.createfolder C:\ + RESERVES
Next
End Su
--
Jim1
-----------------------------------------------------------------------
Jim15's Profile:
http://www.excelforum.com/member.php...fo&userid=2630
View this thread:
http://www.excelforum.com/showthread.php?threadid=51194