Wednesday, October 3, 2012

VBA Create a Directory

Sub Create_A_Directory()
' ______________________________________
'
' This macro creates a directory where you want
' It works both in Excel and Word VBA
' ______________________________________

On Error Resume Next

MkDir ("C:\Temp") 'this creates a directory named Temp on your C:\ drive

End Sub

1 comment:

You may comment or show me other VBA tricks, but don't rest assured I'll always reply because I only have 24 hours in a day's hard work, and only a few minutes a week to update this blog... I'll try my best though...