Hello:
I need to add code in existing Outlook VBA to delete files MM-DD-YY_*.xls from folder C:\Temp\
MM, dd YY will be from Todays date.
Please let me know if you have any questions.
Thanks.
Riz
Hello:
I need to add code in existing Outlook VBA to delete files MM-DD-YY_*.xls from folder C:\Temp\
MM, dd YY will be from Todays date.
Please let me know if you have any questions.
Thanks.
Riz
"Air Code"
![]()
Sub DeleteFiles() Dim PathName As String ' Path to folder with file Dim FileName As String ' Working file name Dim DateStamp As String ' initalize variables DateStamp = Format(Now(), "mm-dd-yy") PathName = "C:\Temp" FileName = Dir(PathName & "\" & DateStamp & "*_xls") While FileName <> "" Kill PathName & "\" & FileName FileName = Dir() Wend End Sub
One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.
A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks