oldfilename = "C:\Users\Sairam\Desktop\daily\crow\abcd_05012017.txt"
newfilename = "C:\Users\Sairam\Desktop\daily\crow\1.txt"
Name oldfilename As newfilename
the above is working.
the below is not working
oldfilename = "C:\Users\Sairam\Desktop\daily\crow\abcd_" & "*.txt"
newfilename = "C:\Users\Sairam\Desktop\daily\crow\1.txt"
Name oldfilename As newfilename
how to use wildcard when renaming a file
Bookmarks