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
Useful VBA Macros for Excel and Word
A compendium of some of my old VBA macros from the most annoying and simple ones to those that defy you at the end of a long day. I had to build the macros to deal with the demands of my job to manipulate strings, cells and files and this blog is a way to sort the most useful macros scattered all over my disks. I am not a professional programmer though, so I will accept absolutely no liability for any damage!
You're welcome, glad it helped.
ReplyDelete