TomExcel1234
New Member
- Joined
- May 17, 2021
- Messages
- 10
- Office Version
- 2016
- Platform
- Windows
Hello, i am trying macro to do following, please. Heres a brief summary:
background (not relevant to macro):
I was trying to delete duplicate frames in a video. I exported video into lets say 10’000 frames and managed to delete 30% of duplicates. However, afterwards i found video in higher quality so i exported second batch of 10’000 frames. If i had a macro to delete duplicates in second batch too, it would save me hours to manually go through second batch and do the same work all over again, please.
Desired Macro:
I have two folders in windows. Folder 1 has 7000 images (format ‘00001.jpg’ to ‘10000.jpg’) where i deleted 30% of duplicate frames. Second folder 2 has 10’000 frames in higher quality where i need to remove duplicates.
Macro should go into folder 2, see if frame 00001.jpg is in folder 1 as well. IF YES, then keep the file 00001.jpg in folder 2 (do nothing), IF NO, then delete file in folder 2 [because its a duplicate]. Then repeat for all 10’000 frames. The macro would be based on naming of files only. It would neither open nor analyze pictures themselves.
i am good with vbas within excel, but never done linking vba to external files, so im clueless. If someone could help, this would save me about 10 hours of manual work, please. Thank you for any help.
background (not relevant to macro):
I was trying to delete duplicate frames in a video. I exported video into lets say 10’000 frames and managed to delete 30% of duplicates. However, afterwards i found video in higher quality so i exported second batch of 10’000 frames. If i had a macro to delete duplicates in second batch too, it would save me hours to manually go through second batch and do the same work all over again, please.
Desired Macro:
I have two folders in windows. Folder 1 has 7000 images (format ‘00001.jpg’ to ‘10000.jpg’) where i deleted 30% of duplicate frames. Second folder 2 has 10’000 frames in higher quality where i need to remove duplicates.
Macro should go into folder 2, see if frame 00001.jpg is in folder 1 as well. IF YES, then keep the file 00001.jpg in folder 2 (do nothing), IF NO, then delete file in folder 2 [because its a duplicate]. Then repeat for all 10’000 frames. The macro would be based on naming of files only. It would neither open nor analyze pictures themselves.
i am good with vbas within excel, but never done linking vba to external files, so im clueless. If someone could help, this would save me about 10 hours of manual work, please. Thank you for any help.