Macro/Scripts for automatically renaming files, creating folders, etc?

[redfishsc]

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.

 

[GokAy]

Perhaps if you could "Save As" the file to a predetermined folder (say, C:\Current Job\) and change its name to "JOB_NAME" while doing so, you can just run the batch afterwards.

The batch would be like:

- Check C:\Current Job for a csv file, set JOB_NAME=csv file's name
- Perhaps also create a TimeStamp (Date-Time) variable=TIMESTAMP
DEL "<folder>\CNCDOC" /Q
MOVE /y "C:\Current Job\JOB_NAME.csv" "<folder>\CNCDOC"
MD "<folder_where_jobs_are_stored>\JOB_NAME_TIMESTAMP"
- Copy the ~100 files to <folder_where_jobs_are_stored>\JOB_NAME_TIMESTAMP (how depends on whether all files will be copied or have to be a subset of files in that folder)
DEL /Q "C:\Current Job\JOB_NAME.csv"

Would this work?