Excel spreadsheet with macros to bulk/batch rename, copy, and move, files in Windows Explorer

  Рет қаралды 36,042

Michael Dew

Michael Dew

Күн бұрын

Пікірлер: 66
@fahadmanzur
@fahadmanzur 3 жыл бұрын
You!, Good sir are god sent. God bless you. Saved so much of my time. I can't believe this only got 2k views. Definitely subscribing.
@iamdonna5918
@iamdonna5918 3 жыл бұрын
Wow!!!! Thank you for this Michael this is really such a big help! Been doing the manual renaming of PDF file for such a long time! Finally save a lot of time bcoz of this! A day will now be a minute only 😍 love this! super helpful 101%
@iamdonna5918
@iamdonna5918 3 жыл бұрын
Hope you can also share how to set password for multiple PDF files 😊
@Howlandta
@Howlandta 3 жыл бұрын
Thanks this is rather useful - I was doing it using CMD, but this is a lot quicker. 1 item to comment on - around the 13 min mark you reference using another methodology for extracting the date modified details for each file. If you copy the location of the files and paste them into the URL bar in Chrome, it will list everything as text. Ctrl+A then Ctrl+C and paste the details into Excel - Job is done! Much quicker ;-)
@MichaelDewTechTips
@MichaelDewTechTips 3 жыл бұрын
Wow, nice, I did not know about that trick with Chrome, thanks for sharing!
@bhaktikishakti6578
@bhaktikishakti6578 2 жыл бұрын
Wow Michael !! thanks fir sharing, its saved my 10 days work.
@pradiptapd
@pradiptapd 3 жыл бұрын
Excellent tool Michael and a great video. Bravo!
@bhautikshah3037
@bhautikshah3037 3 жыл бұрын
No words..thanks a lot...amazing
@ertugilmez
@ertugilmez Жыл бұрын
Bravoo👏👏👏
@nektariakazakopoulou553
@nektariakazakopoulou553 2 жыл бұрын
Wow thank you so much, work’s amazingly! Just a question, we cannot rename subfolders is that correct ? Only files?
@MichaelDewTechTips
@MichaelDewTechTips 2 жыл бұрын
You can rename folders, use the 'Rename paths ("Move")' tab. As per the instructions on that tab: CAN change the paths of folders (including folders that contain subfolders and files), but when listing the current and target paths of folders to be renamed specify only the portions of the paths up to and including the end of the old and new folder names. CAN'T change the portion of a path before the file name, or before the last folder name (if the path ends with a folder), i.e. the target "parent folder" paths must already exist.
@anvishlok
@anvishlok 3 жыл бұрын
This is mind blowing and really helpful.
@rafaelcruz9570
@rafaelcruz9570 3 жыл бұрын
Amazing!! Thank you.
@HCA61
@HCA61 3 жыл бұрын
Very helpful. Thanks a lot!
@Matawfik
@Matawfik 3 жыл бұрын
Really, that is like a magic tools Thank you
@manojitkarar
@manojitkarar 3 жыл бұрын
U deserve millions bro
@GeorgeAlxs
@GeorgeAlxs 2 жыл бұрын
Hello Michael, I purchased your spreadsheet, but I get an error that it can not run the macro. Could you help me?
@MichaelDewTechTips
@MichaelDewTechTips 2 жыл бұрын
Sure, you can email me at legaltree at gmail dot com.
@seanchadee762
@seanchadee762 3 жыл бұрын
Thanks this really helps
@wadeharrison2
@wadeharrison2 2 жыл бұрын
Any way to get a little support? Love the idea and the flexibility and the simple instructions and functionality... but getting a run-time error even after passing the "pre-check for errors" on Rename Files In Place... 145 files for which I pasted into the last column (rather than edit original names) the new filenames, as text, with extensions, from another spreadsheet.
@MichaelDewTechTips
@MichaelDewTechTips 2 жыл бұрын
That seems strange. If you email me your spreadsheet (see email address on about page) with the content you pasted in then I can take a look at it...
@wadeharrison2
@wadeharrison2 2 жыл бұрын
@@MichaelDewTechTips will do, thanks for the quick reply!
@MichaelDewTechTips
@MichaelDewTechTips 2 жыл бұрын
FYI for others, the issue was an open file which interfered with renaming - do remember to close all files before running the renaming macro.
@sentissimk
@sentissimk 3 жыл бұрын
so helpful thank you
@olliesplace4533
@olliesplace4533 Жыл бұрын
I bought this macro 6 months ago. It is excellent. However I moved this file from one folder to another for easier access. It is disabled. I have tried to enable in trust centre, it still does not work? Do you have any suggestion to resolve this? Or do I have to pay again to redownload? Thank you
@MichaelDewTechTips
@MichaelDewTechTips Жыл бұрын
No, your file should not have expired yet, and you will get an express message to that effect when that occurs. Probably it is a security setting on your PC. You should make the location the file is saved in a "trusted location", see notes at the link in the description.
@olliesplace4533
@olliesplace4533 Жыл бұрын
@@MichaelDewTechTips Thank you Michael for your quick reply. I have tried the following steps. However, it still does not work. "Add the file location to the trusted locations: You can add the new location where you have moved the xlsm file to the Trusted Locations in Excel. Go to "File" > "Options" > "Trust Center" > "Trust Center Settings" > "Trusted Locations". Add the folder location where the xlsm file is stored in the "Path" section".
@MichaelDewTechTips
@MichaelDewTechTips Жыл бұрын
@@olliesplace4533 send me an email at legaltree at gmail and I will reply with a fresh file just in case the file somehow got corrupted (?)
@vincysigma
@vincysigma 3 жыл бұрын
Waw... Very nice.. Thanks you..
@blackrandy77
@blackrandy77 2 жыл бұрын
Hi, The rename paths function is throwing an error and not allowing me to run the macro. The paths exist, they're spelled right, I have copied as values but I cannot seem to get it to run. I even renamed the file names to numbers just to see if it was a formatting of the file names in the folders themselves. Not sure what else to do
@MichaelDewTechTips
@MichaelDewTechTips 2 жыл бұрын
If you email me the file I will take a look at it. You can get my email address from the "about" page of my youtube channel. Even though I will not have the corresponding library of files I may be able to draw some conclusions by looking at your data.
@blackrandy77
@blackrandy77 2 жыл бұрын
@@MichaelDewTechTips thank you, just emailed you
@MichaelDewTechTips
@MichaelDewTechTips 2 жыл бұрын
@@blackrandy77 hmmm...it did not come through yet, did you send it to legaltree "at" gmail ?
@badrawyman4471
@badrawyman4471 3 жыл бұрын
Bravo!
@soohonwing2078
@soohonwing2078 3 жыл бұрын
it works great
@mohitjain828
@mohitjain828 3 жыл бұрын
Thanks man
@redbeardcreative
@redbeardcreative 3 жыл бұрын
GOAT
@mohamedshennib
@mohamedshennib 3 жыл бұрын
it is magic you are amazing reallyyyyyyyy really thaaaaaaank you man
@ilvdp4ever
@ilvdp4ever 3 жыл бұрын
You are amazing! Is there a direct shortcut key to paste data as value?
@MichaelDewTechTips
@MichaelDewTechTips 3 жыл бұрын
"Ctrl + V", then "Ctrl", then "V". Actually goes pretty quick once you get the hang of it i.e. you can do those three steps in very quick succession.
@electroheight
@electroheight 2 жыл бұрын
we have lots of excel file ...then how to convert the excel file name with the specific cell value.... every file have different cell value....
@MichaelDewTechTips
@MichaelDewTechTips 2 жыл бұрын
Sorry, I do not understand your question, you will have to be more clear...
@ufahadgazi
@ufahadgazi Жыл бұрын
this video is very well but i didn't find the excel file can you give excel file ?
@MichaelDewTechTips
@MichaelDewTechTips Жыл бұрын
Follow the link in the description. It is a paid download.
@e-lib4all441
@e-lib4all441 3 жыл бұрын
I get this error. How do I fix it? "The file extension for the new name does not match the file extension for the new name. Spaces on the end of the new name may trigger this error"
@MichaelDewTechTips
@MichaelDewTechTips 3 жыл бұрын
The file extensions for both the old file name and the new file name must match. A space on the end of the new file name could cause the macro to detect an error. Before running the macro you can use the TRIM function in Excel to remove spaces from the end of contents. exceljet.net/excel-functions/excel-trim-function
@e-lib4all441
@e-lib4all441 3 жыл бұрын
@@MichaelDewTechTips Still couldn't work. We were trying to reply to your email but it says "noreply".
@MichaelDewTechTips
@MichaelDewTechTips 3 жыл бұрын
@@e-lib4all441 If you want you can get my gmail address from the "about" page on the youtube channel and email me your spreadsheet with data in it and I can take a look at it (may take a day or so to get to it though).
@e-lib4all441
@e-lib4all441 3 жыл бұрын
@@MichaelDewTechTips Thanks, sent!
@MichaelDewTechTips
@MichaelDewTechTips 3 жыл бұрын
In case others might benefit from this clarification: every file needs a complete new name, including a proper file extension (e.g. ".pdf"), and the file extension of the new file name on each row must match the file extension of the old file name on that same row.
@fffotofilippi
@fffotofilippi 3 жыл бұрын
Hi Michael Great video - could you please help or direct me to one of you vids. I have hundreds of files with unique names. I have then produced those files into basic file names but in order as originals. Eg. OLD NEW ancdef.jpg = _01.mp4 bcffgff.jpg = _02.mp4 ...and so on. I would like to replace new names back to original names. Thank you for your help Frank
@MichaelDewTechTips
@MichaelDewTechTips 3 жыл бұрын
You should be able to use the "rename files in place" sheet as explained starting at 0:53 in the video. You cannot change file name extensions, so the new names and old names have to have the same file extensions. You can use Excel functions such as LEFT, RIGHT, LEN, VLOOKUP, etc. to juggle the data before applying the renaming.
@Calicrazedbeats
@Calicrazedbeats 2 жыл бұрын
I tried multiple times doesnt seem to work with zip or audio files
@MichaelDewTechTips
@MichaelDewTechTips 2 жыл бұрын
I have an updated version that I have been experimenting with that has better code and may work for your files. If you email me I will email you a copy of that updated version to try out. Also, I will likely soon upload that improved version.
@Calicrazedbeats
@Calicrazedbeats 2 жыл бұрын
@@MichaelDewTechTips great thanks
@Calicrazedbeats
@Calicrazedbeats 2 жыл бұрын
@@MichaelDewTechTips I got it to work finally lol just need to moove it to like 2-4 more subfolderes
@MichaelDewTechTips
@MichaelDewTechTips 2 жыл бұрын
@@Calicrazedbeats Glad you got it to work, but can you clarify, did the original spreadsheet you downloaded work, or just the new one I emailed you? Also, is it working perfectly or would you say there is still a bug / shortcoming in the spreadsheet?
@Calicrazedbeats
@Calicrazedbeats 2 жыл бұрын
@@MichaelDewTechTips The downloaded file works ok. At a certain point glitches sometimes like the file name extrated will display accross the entire row after first column. I have to repeate the process twice to get the tiles to move down to the 5th or sixth subfilder. I have not received the emailed update
@rajmitra4715
@rajmitra4715 Жыл бұрын
Hello. I am from India and I cannot be able to make the payment
@MichaelDewTechTips
@MichaelDewTechTips Жыл бұрын
Other people have purchased from India, but you could try a VPN if needed.
@rajmitra4715
@rajmitra4715 Жыл бұрын
@@MichaelDewTechTips it's saying unable to process your request.can you please say any alternate way to pay
@MichaelDewTechTips
@MichaelDewTechTips Жыл бұрын
@@rajmitra4715 email me at legaltree "at" gmail.com
@hanshans8085
@hanshans8085 2 жыл бұрын
I cant kiss you. But I would! Damn this so helpful. You created a new horizen in my mind!
@raymartcarlos8166
@raymartcarlos8166 2 жыл бұрын
this is free?
@MichaelDewTechTips
@MichaelDewTechTips 2 жыл бұрын
No, currently, it costs just a bit more than a fancy cup of coffee...
Excel VBA  with FILES function to rename files
7:49
ExcelMoments
Рет қаралды 22 М.
How to rename multiple files in Windows
14:10
Karina Adcock
Рет қаралды 126 М.
2 MAGIC SECRETS @denismagicshow @roman_magic
00:32
MasomkaMagic
Рет қаралды 16 МЛН
MY HEIGHT vs MrBEAST CREW 🙈📏
00:22
Celine Dept
Рет қаралды 91 МЛН
Try Not To Laugh 😅 the Best of BoxtoxTv 👌
00:18
boxtoxtv
Рет қаралды 6 МЛН
Stop Wasting Time! 3 Easy Ways to Remove Blank Rows in Excel
10:20
Leila Gharani
Рет қаралды 106 М.
Move or Copy List of Files
14:38
William Campbell
Рет қаралды 4,8 М.
Excel for Beginners - The Complete Course
54:55
Technology for Teachers and Students
Рет қаралды 7 МЛН
3 Essential Excel skills for the data analyst
18:02
Access Analytic
Рет қаралды 1,5 МЛН
An Introductory QGIS Workshop for Beginners
3:49:41
QGIS North America
Рет қаралды 552 М.
7 Things You're Doing WRONG⚡in Excel
15:22
Leila Gharani
Рет қаралды 1,2 МЛН
Rename Multiple Files in Windows at Once using Excel
7:57
Omar Hamed
Рет қаралды 24 М.
Loop Through All Files in a Folder Using VBA/Macros in Excel
13:41
2 MAGIC SECRETS @denismagicshow @roman_magic
00:32
MasomkaMagic
Рет қаралды 16 МЛН