Hello,
I have code to populate files names in column B, what I want new procedure to combine with original code . so the new procedure should use dialog inputbox first write specific file name after click ok show new inputbox to write word in inputbox after that should rename file name in column A and rename file name within folder or subfolder is existed in selected folder.
ex1:
1- first step inputbox I write just number as in B2=25,700
2-second step inputbox I write word "DON" then the new file name
in A2=INVOICE 25,700 DONE
3- third step rename file in folders and subfoders for selected folder.
ex2:
1- first step inputbox I write just number as in B3=25,240
2-second step inputbox I write word "CURRENT" then the new file name in A3=INVOICE 25,240 CURRENT
the words should add in the end of numbers.
3- third step rename file in folders and subfoders for selected folder.
important: could be there are files contains the same name but within subfolders so should rename first and when run again then should rename next (don't rename the same files names at once)
thanks
Reply With Quote