New
#1
Macro/Scripts for automatically renaming files, creating folders, etc?
I may be asking a bit much, but we have a certain process we do at our cabinet manufacturing facility frequently that I'm hoping to reduce the number of steps. I need something similar to a macro that will do the preprogrammed things I tell it to---- copy files from certain areas, paste them into other areas, and possibly even renaming files with a preprogrammed name.
Basically this is just a matter of moving files, deleting one file, pasting another, renaming that file, etc. It just takes a while.
Essentially, my customer fills in a Google Spreadsheet document template I've prepared with their order quantities. We have to download this file, rename it, paste it in a very specific folder. This makes it accessible to our CNC machine's computer so that it can make a list of the things it's going to cut.
Here is what I am currently doing, and I'm hoping someone can help me drastically reduce the number of keystrokes.
1) Open the spreadsheet in Google Docs, click on "File: Download as CSV".
2) Show this document in download folder, copy/cut it.
3) Open the destination folder, delete a file named "CNCDOC" (old data from previous cut list).
4) Paste this copied csv file, and rename it as "CNCDOC".
5) Open a second specific folder. In this folder, create a new folder named "JOB_NAME" (obviously it's different each time).
6) Copy about 100 files from a certain folder, and paste it in the folder made in step 5.
Doing this repeatedly every day gets rather bothersome, and I'm hoping to find a macro of some sort that will at least automatically copy/paste the stuff in step 6.