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

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

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

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

Thread Tools

Similar help and support threads
Thread Forum
Getting "Item Not Found" when creating or renaming folders in explorer
I've been using RT7 Lite over the past few months to create a fully updated Win-7 SP1 installation image that includes drivers for the hardware I have, and does not include any of a dozen or so "bad" telemetry or win-10 nagware updates. For the record this is Win-7, Ultimate, SP1, 32 bit. I've...
General Discussion
Looking for macro creating software!
I want a program that can create simple macros for me. For example: I want to have Shift + Num1 = U. The purpose for this is for me to be able to macro some games for easier play. I saw Intellitype pro for windows 10 but I dont have one of their keyboards. Can anyone offer up a program?
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
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
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 06:57.
Twitter Facebook Google+