Test if a folder exists
You could use an error trapper as mine that I use to backup from current
directory
Sub Backup() 'kept in personal.xls & assigned to toolbar button
On Error GoTo BackupFile
MkDir CurDir & "\Backup"
BackupFile:
With ActiveWorkbook
MyWB = .Path & "\BACKUP\" & .Name
.SaveCopyAs MyWB
.Save
End With
End Sub
"Jeff Marshall" wrote in message
...
Hi,
I am making a folder using VBA called "SeptInv" in C:\Billing\Invoices\ .
However before the folder is made I don't know how to;
1. Test if the SeptInv folder has already been made and
2. Once it has been made that my VBA macro doesn't try to make it again.
Thanks in advance for any help.
Jeff
|