Windows 7 Forums

Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.


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

01 Aug 2015   #1
redfishsc

Work: Win7 Professional X64 : at home, Win7 Home X64
 
 
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.


My System SpecsSystem Spec
.
01 Aug 2015   #2
GokAy

Windows 7 Ultimate x64 SP1
 
 

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?
My System SpecsSystem Spec
Reply

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




Thread Tools Search this Thread
Search this Thread:

Advanced Search




Similar help and support threads
Thread Forum
BULK creating of folders based on file names, and then moving files in
Hi Everyone, i have been looking for weeks for a way to do this and i have tried so many applications but i just cant seem to get it right, i was hoping that you guys my be able to help me out here with this one.. i have two folders, at the moment with identical file names in the ( they...
General Discussion
Automatically creating shortcuts for new files and folders
We currently have a user who has recently been upgraded to Windows 7 x64 and has this weird issue with shortcuts. When this user creates a new file or folder on a network share it's also creating a shortcut in the root of the share. This is only affecting this user and the only thing I can think of...
Network & Sharing
"Item not found" bug when moving or renaming files/folders
Hello, I just made an account here because this bug is seriously bugging me. It shows up whenever I move or create any new files/folders. I have googled the registry fix and that doesn't seem to be working. Is there any other known fix? P.S. There is nothing wrong with Waterfox.
General Discussion
Renaming and deleting folders and files problem
Hi there What i describe below doesn't always happen but it does lots of times: let's say I delete a folder.... it will tell me that access is denied, a program is using it.... to solve that, I have to open another folder, or click on an image, then go back to the folder I want to delete, and...
General Discussion
Windows 7 hangs when creating and renaming new folder
Ok, so I have a problem where Windows 7 hangs when creating a new folder and hangs again when renaming it. I have documented this problem on my blog here: This has my hardware details, etc... I consider myself an expert at troubleshooting (being in support for over 10 years including...
BSOD Help and Support
automatically delete/move files to folders
hi all! is there something like a handy method to automatically move files depending on their extension to custom folders? (either by the time they are generated or at a specific date). ps: b.) i would be also interested in finding a method to have windows7 delete files in custom folders at a...
General Discussion


Our Sites

Site Links

About Us

Find Us

Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

Designer Media Ltd

All times are GMT -5. The time now is 19:34.

Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App