Search the Community
Showing results for tags 're-usable'.
-
So I am new to coding outside of VBA / SQL, and have been trying to figure out a way to automate the following: 1. Transfer all files from a folder (folder1), to another folder (folder 2), AND be able to specify two constraints for the names of the files to be transferred. For Example: I want to be able to specify to transfer all files containing both "MDXv3" and "_2012" in their file name, and I am thinking of something close to the LIKE '%abcd'; function from SQL 2. After the specified files have been transferred from folder1 to folder2, I need to unzip all the files in folder2 using 7zip (extraction location is folder2) 3. After extracting the files, I want to have it automatically delete all files ending in ".dec" and then edit part of the name out of all the files ending in ".txt" for example: I would want to be able to specify that "145_" is to be deleted from the file name of every ".txt" file My goal here is to automate the transferring, unzipping and editing of extracted files. I need to have a macro for this because I am only looking for specific files in folder 1, say 350 files, but there are some 10k+ files, and the files I am looking for are not named in an easily organized fashion (this is done out of necessity, not choice so I am unable to change the original archiving file names of the files I am working with) So far I have been trying to use a macro recorder to do this but the task is a bit too complicated for a simple recording Thank you for the help ahead of time, I really have been struggling with this
- 2 replies
-
- macro
- automation
-
(and 2 more)
Tagged with: