Over 1 million tech questions and answers.

CMD: Copy files that are listed in a text file.

Q: CMD: Copy files that are listed in a text file.

Situation: I have the simple CMD(DOS) .bat below that i am using to scan networked computers for specific files that need to be overwritten. When the file is found, its path is appended to the resutls log (MS08-070_compname.txt). I am trying to figure out how to read that results log to automatically overwrite those files with the updated files.

Limits: Cannot use any third-party software, cannot use GPO, pretty much can't use much else than the DOS CLI basically. A HUGE! annoyance, trust me, I know. I am quite aware of how old the DOS CLI is and that there are much better tools out there, I just simply cannot use them due to implemented network limitations.

Thanks in advance for any help provided!
@echo off
set /p cname="What is the computer name to search? \\"
echo Now searching for ComCt232.ocx (1 of 8) . . .
dir \\%cname%\c$\ComCt232.ocx /b /s > %userprofile%\MS08-070_%cname%.txt
echo Now searching for MSChrt20.ocx (2 of 8) . . .
dir \\%cname%\c$\MSChrt20.ocx /b /s >> %userprofile%\MS08-070_%cname%.txt
echo Now searching for mscomct2.ocx (3 of 8) . . .
dir \\%cname%\c$\mscomct2.ocx /b /s >> %userprofile%\MS08-070_%cname%.txt
echo Now searching for MSDatGrd.ocx (4 of 8) . . .
dir \\%cname%\c$\MSDatGrd.ocx /b /s >> %userprofile%\MS08-070_%cname%.txt
echo Now searching for MSFlxGrd.ocx (5 of 8) . . .
dir \\%cname%\c$\MSFlxGrd.ocx /b /s >> %userprofile%\MS08-070_%cname%.txt
echo Now searching for MShflxgd.ocx (6 of 8) . . .
dir \\%cname%\c$\MShflxgd.ocx /b /s >> %userprofile%\MS08-070_%cname%.txt
echo Now searching for msmask32.ocx (7 of 8) . . .
dir \\%cname%\c$\msmask32.ocx /b /s >> %userprofile%\MS08-070_%cname%.txt
echo Now searching for MSWINSCK.ocx (8 of 8) . . .
dir \\%cname%\c$\MSWINSCK.ocx /b /s >> %userprofile%\MS08-070_%cname%.txt
echo Results published to: %userprofile%\MS08-070_%cname%.txt
set /p ="Search complete! Press [Enter] to close"

Preferred Solution: CMD: Copy files that are listed in a text file.

I recommend downloading and running Reimage. It's a computer repair tool that has been proven to identify and fix many Windows problems with a high level of success.

I've used it in the past to identify and fix everything from blue screens (BSOD's), ActiveX errors, corrupt files and processes, dll/exe/sys errors, recover lost memory, Windows update problems, defragging, malware removal etc.

You can download it direct from this link http://downloadreimage.com/download.php. (This link will automatically start a download of Reimage that you can save to your computer.)

A: CMD: Copy files that are listed in a text file.

Read other 6 answers

I want to copy the text of files to post in forums...example-I am a music artist, i have an album i am tryin to promote. I did a promo album for free dowload. I want to be able to copy the all the names, at once, from the files in the folder for the promo album...I usally write them out and then save in notebook, but there iare other albums i did, and i dont want to have to write everthing out. So how do i copy the files as text or change the files to text...now i know i can do them one by one, but i would llike to do be able to copy all the song names...Thanks.

A:Copy Files As Text?

Found a way and it works! http://www.codeproject.com/KB/shell/copylocation.aspx

Read other 2 answers


I have 30 different files in the same path, but the name of the each file should be different, how i can combine all the files data into a single text file.

If there is any macro will help me solve this.

Thanks in advance!!!

A:Solved: Combining 30 text files into single text file

Read other 16 answers

Hi. I have a question I think the answer is a lost cause, but I really need help. I  didn't know which forum to post this in, but I'm asking that it be moved by administrators wherever needed, but I need assistance. I use a screen reader. It is something that reads to me because of my low vision. OK? Well, I need to copy text on a PDF file  but when I select text and then right click I don't have the option to copy, Pressing Ctrl/C isn't going to do a bleep thing. So, I need to do this. Not for stupid copyright violation, but because otherwise, this file is useless, and I'm requred to read this. Is it even possible to take care of this? ITS VERY IMPORTANt. Here's this link I'm tring to copy the text off of.
Thank you, and GOD BLESS!!

A:Have to Copy text on a PDF file but unavailable

If you use Adobe Reader 11...
On the toolbar, Click View, Click Read Out Loud,
Best of luck and Please keep BC posted!

Read other 3 answers

Can anyone tell me how to copy file names in Windows Explorer as a text list so I can paste them into a Word or Excel document? I have many home video files that were named, by default, as the date & time of recording and usually contain 14 digits, e.g., 20120310145034. I want to rename them (by adding additional details) but I also want to be able to manipulate (sort or print) the list. Obviously I don't want to retype each one of the numbered files.

A:Is there a way to copy file names as text?

Hi ircool and welcome to the Forum.
Try this, right click on the file name in Win Expl and click "Properties" should open in General tab. Then just highlight the file name and press Ctrl + C. Open your chosen program and Press Ctrl + V at the curser position and the should do what you need. Of course this means doing each file separately

Read other 5 answers

I received a file in .pdf extension and I wanted to copy the text from the file. Then I checked for properties of the file which showed that file has been made in CorelDRAW and the converted into pdf. Now I want to copy the text from the file. Please help

A:.cdr file converted to .pdf not able to copy the text

If it is a CorelDraw image within this pdf, then you will need to use a OCR program to convert from a image to text.

Most scanners come with a OCR program.

Read other 1 answers

How do I copy database search results to a text file?

I was trying this but appaently it did not fly.

select * from categories << f:\myfile.txt

A:How to copy database search results to a text file?

Read other 6 answers

I noticed this change a month or two ago. When in Photoshop, Dreamweaver, or several other apps, and from within the program I'm trying to open a file or link to one (in Dreamweaver's case), they're now listed by filesize (instead of by name) in the folder. Obviously this makes it hard to find the one I'm looking for.

When I manually select "Arrange Icons by... Name", it re-sorts them but resets every time I'm in the "Select/Open File" dialogue again. Browsing folders through Windows Explorer from My Computer does not have this problem - files are sorted correctly - only in applications does this come up. Have tried setting Sort By Filename as the default, but can't get anything to stick.

Never seen this happen before, and it's getting fairly aggravating as it's a frequent task in my workday. Any ideas what the problem could be?

PS - I should note that this is not the virus-infected computer in my other recent post - that's my laptop. This desktop is totally clean as far as I know, have scanned with multiple programs and aside from this problem there's no unusual behavior.

Thanks in advance...

A:Files being listed by filesize (instead of by name) in applications' "Select File" windows

I've seen this phenomenon...and I think it's only with music/graphics/video-editors which I have installed.

I've assumed that chkdsk /r needed to be run on my C: and that's been followed by normal behavior. May not work for you, but no harm in trying it.

My last episode with this was 72 hours ago .


Read other 2 answers

I have so many films and music, how do i compile a list of them into a text file or some other format for catalogue use? , i hate using catalogue software.

A:How to compile a text file or similar regarding files?.

If you are talking about mp3s, the free mp3utility application can quickly generate a txt file of all mp3s in a certain directory.

You can leave that txt file in that format or import it into Excel for more sorting capabilities.

I'm sure you can do something similar from a command prompt.

Read other 1 answers

I know there are solutions for this on this forum but I can't get any of them to work in my specific situation.

I have a program that cannot deal with ZIP files and I need to manually sort them out. What I can do is export a partial location for these ZIP files to a txt files so I have:


What I want to be able to do is create a batch file that will read the location of these files and copy them to a folder. The files are located on a network share but they r are mapped in My Computer. I can modify to the txt file so it gives the full path as a UNC path or a hard path.

I've been trying to get it to work using a For In Do statement but I don't know if that's the best solution. Help would be greatly appreciated. Thanks.


A:Batch file to copy files

If you need to replicate the folder structure you need to use xcopy or robocopy.
Posted via Mobile Device

Read other 2 answers

Hi everybody

I need help for reading data from text files and saving it under different columns in the excel file using vba macro.

For example: I have many text files in the following format

File 1:
1 2 3 4
1 3 5 7
1 3 1 8

File 2:
1 2 3 4
1 3 5 7
1 3 1 8

In excel file the above files should be saved one below the other seperated by the name of the text file, in seperate coumns as found in the text file.

I found an example online but it saves the data under a single column only. I tried changing it to my requirement, but I couldn't. I have attached the example that I found online.


Read other answers

i am looking to make text documents of all my files i have located on exterenal hard drives. so i can see what i have on the drives without hooking them up.

also when putting data onto DVD's it is nice to be able to quickly make a list.
i am sure there is a fast easy way to do this.

A:Make A Text File List Of Files In A Folder

^ you are working with windows - right ?freewares available for the above task .one such freeware utility is file listit is a commandline utility . see details

Read other 24 answers

I had a folder from my documents and i placed it into the director of my 2gb thumb/flash drive and it said it moved, then at the end it said that it couldn't move the folder. I just watched it move all these files to the drive that are now gone, just because the folder itself wouldn't move. Any help or ideas will be appreciated, Thank you.

A:File copy/move fail, now files gone?

It should have created a copy...I usually don't pay attention to such, but I think that's what happens.

The files are either moved, copied...or in one location or both.

They don't just disappear, unless one of your drives is defective.

Try running chkdsk /r on the flash drive.


Read other 1 answers

I've just bought a new laptop and I need to move my personal files from the old one to the new one. I've tried several methods, but they all give me problems with certain files: some files (and I have not been able to find any pattern here) will simply not copy over.

What I've done:
Move files onto an external USB drive and then copy them onto the new laptop.
Take out the old HDD and connect it to the USB port of my new laptop.

In both cases there are files that request admin permission before starting to copy, but the admin permission of my new laptop does not work for those files.

How can I get all my files on my new laptop with as little hassle as possible and without losing any files?

P.S. I did not set any special file permissions for any of the files and it looks like most of the files that won't copy over came from email or forum attachments, support downloads from hardware manufacturers etc. This has me even more puzzled since these files are supposed to be shared and should copy over without any problems...

A:Copy files to new PC - file permission problems


What type of files are you trying to move?


Read other 9 answers

Hi all,

To increase our backup solutions, we have decided to backup our SQL database every hour to a folder within the C drive (we couldn't get it to backup straight to a USB drive). So now we need a way (batch file best solution?) to copy these files to the USB drive, lets say every 1.05hours just after they've been created?

Maybe we could copy the entire folder every hour and delete old backups that are in this folder and to the new place for the backups. (although I guess it won't work as it'll have the same folder name once it has been copied).

Or copy the individual files to that new folder although with this they have all different names so is it possible to copy the newest file to the new folder and then after this delete the old backups from a certain time frame?

Big thanks for your help!

A:Batch file to copy files from C drive to USB

REM Creates a Backup of files every hour
@echo off
XCOPY <source path> <destination path> /w /f /-y
TIMEOUT /t 3600 /nobreak
goto start
This might work, I'm no expert by any means, but the batch file should copy all the files, and then pause for a hour, and then loop back to the start and complete the same process again.

Here's what the XCOPY switches mean - http://www.microsoft.com/resources/d....mspx?mfr=true

Read other 9 answers

I have a DVD with a video clip file which lacks file extensions, the file has certainly been copied fully and without errors, I believe the only problem is the name but I don't have a backup of that on my computer so I'm stuck. I need to copy this file from my DVD to my computer but it says that "it cannot read from file or source disk". Is there a program which bypasses the fact that my video clip has no file extension will copy it to my pc just the same?

A:program to use for copy of CD with no-file-extension files

Read other 7 answers

I have been trying to delete pics. When i press control and click on each pic to delete a bunch at one time, I get copies of the files im trying to highlight. I thought I was clicking on create shortcut, but it is creating a copy of all I have highlighted even before I get to the delete menu.
Anyone heard of this before? What am I doing wrong?
Thanks in advance.

A:deleting files creats a copy of that file

Read other 8 answers

Hello All,

I am looking for something to help me in my work. I have to keep line counts in text and CSV files in a log. I was wondering if it was possible to do this with a batch file?

Here is what i would like for it to do:
Open the DOS window in XP.
Drag the Bat file to the dos window
Drag the file needing to be counted to the same window(or copy the network address), click enter
and have a line count

Currently I use KEdit to get this information from the status bar (size) but thought a batch file might be easier (and quicker).

Can someone help me?

Tannks a bunch

A:Solved: Batch File for Counting Lines in Text or CSV files

Did some Googling around, never really thought of doing this in a batch file. I found a VBscript alternative you might be able to use from command line though.


here's a vbscript alternative:


Set objFSO = CreateObject("Scripting.FileSystemObject")
Set objArgs = WScript.Arguments
myFile = objArgs(0)
Set objFile = objFSO.OpenTextFile(myFile,1)
Do Until objFile.AtEndOfLine
line = objFile.Line
WScript.Echo "Line count of", myFile , "is", line

cscript myscript myfile

The link above is the link to the page where I found this information, wanted to give credit where credit is due. With this script you could just call the script and give it the parameter my file from command line. If you really wanted a batch, you could easily create a batch that echo's each of those lines into a temp.vbs, calls the temp.vbs with a parameter %myfile using the "cscript myscript myfile" command then "del temp.vbs" at the end. Seems very redundant and pointless though.

Hope the VBS helps you.


Read other 3 answers


I'm not sure that this is the good sub-forum for my question ; please excuse me if i'm wrong.

I'm using Windows 8

I need to renames multiples files :
I have a folder with 850+ files (.jpg images) ; the title of each file is always using the same patern : (no space between items)

"BGA" "Number" "_" "TextA" "_" "TextB"

For example :


I need to renames all files to have them in this pattern :

"TextA" "_" "TextB" "_" "Number"

So with the previous example the file names become :


I found on Google softwares to just erase text on multiple file name, or replace it. But not "moving it".
How can I do that so I do not have to edit all file name myself ?

Thank you very much by advance for your help.


A:Rename multiple files : moving text in file name (not replacing)

This may not be what you want, but you can do a batch rename with Photoshop, or the free IrFanView program:

You Tube

Read other 6 answers

Hi my friend,
Everyday a lot of new text files are created in a specific directory by an electronic invoice software. Nobody know why but in the end of the file there are a lot of blank spaces and it is causing a lot of problems when we're going to process all of them.
I removed these blank spaces from the end of the files manually and all files were processed well.
So I'd like to ask if somebody could help me to create a batch to remove double (or more) blank spaces from the files.
Thanks so much

A:Batch File to Remove Blank Space in Text Files

This worked for me under XP, I found it on another site. On the command line use the original file name and a new name to represent %1 and %2.

For example: CleanFile.bat OriginalText.txt NewFile.txt

@Echo Off
For /F "tokens=* delims=" %%A in (%1) Do Echo %%A >> %2

Read other 1 answers

Hello everyone,

Take it easy on me, i am a total noobie

I have a simple WPF App in C# that exports data from SQL to individual .TXT files. It works great except it dumps all the data in one single directory. I am trying to figure out how to have it create the TXT files in a different directory every Nth file.

For example - if i have 100,000 text files it dumps them in one DIR and ideally i would like it to create 100 files and then increment the DIR .

So it would do something like
C:\txtdumps\text001 (100 txt files)
C:\txtdumps\text002 (100 txt files)
C:\txtdumps\text003 (100 txt files)
C:\txtdumps\text004 (100 txt files)
C:\txtdumps\text005 (100 txt files)
C:\txtdumps\text006 (100 txt files)
C:\txtdumps\text007 (100 txt files)
and so on.

any suggestions on how i can accomplish this?

This is what it basically looks like:


FileName = rdr.GetString(0);
text = rdr.GetString(1);
if (string.IsNullOrEmpty(text)) continue;
filePath = filePathOut + FileName.ToString() + ".txt";
if (!System.IO.File.Exists(filePath))
using (sw = new StreamWriter(filePath))
... Read more

A:Solved: C# WPF - Export Text files and increment every nTH file to new directory

You have all the pieces, just need to append filepathout with the appropriate increment when the condition is met.

Edit: If this is going to be a continuous thing you'll need to get a count of files in the latest directory.

Read other 6 answers


I'm not sure that this is the good sub-forum for my question ; please excuse me if i'm wrong.

I'm using Windows 8

I need to renames multiples files :
I have a folder with 850+ files (.jpg images) ; the title of each file is always using the same patern : (no space between items)

"BGA" "Number" "_" "TextA" "_" "TextB"

For example :


I need to renames all files to have them in this pattern :

"TextA" "_" "TextB" "_" "Number"

So with the previous example the file names become :


I found on Google softwares to just erase text on multiple file name, or replace it. But not "moving it".
How can I do that so I do not have to edit all file name myself ?

Thank you very much by advance for your help.


A:Rename multiple files : moving text in file name (not replacing)

This may not be what you want, but you can do a batch rename with Photoshop, or the free IrFanView program:

You Tube

Read other 6 answers

Could someone analyze this dmp file and let me know what is causing this issue? Thank you.

A:BSOD this while trying to copy files over a network. DMP file attached

STOP 0x0000007E: SYSTEM_THREAD_EXCEPTION_NOT_HANDLED Usual causes: Insufficient disk space, Device driver, Video card, BIOS, Breakpoint with no debugger attached, Hardware incompatibility, Faulty system service, Memory, 3rd party remote control,

Microsoft (R) Windows Debugger Version 6.11.0001.404 AMD64
Copyright (c) Microsoft Corporation. All rights reserved.

Loading Dump File [C:\Users\richc46\AppData\Local\Temp\Temp1_092410-25693-01[1].zip\092410-25693-01.dmp]
Mini Kernel Dump File: Only registers and stack trace are available
Symbol search path is: SRV*c:\symbols*http://msdl.microsoft.com/download/symbols
Executable search path is:
Windows 7 Kernel Version 7600 MP (8 procs) Free x64
Product: WinNt, suite: TerminalServer SingleUserTS
Built by: 7600.16617.amd64fre.win7_gdr.100618-1621
Machine Name:
Kernel base = 0xfffff800`02c1a000 PsLoadedModuleList = 0xfffff800`02e57e50
Debug session time: Fri Sep 24 09:26:00.528 2010 (GMT-4)
System Uptime: 0 days 16:49:26.448
Loading Kernel Symbols
Loading User Symbols
Loading unloaded module list
* *
* Bugcheck Analysis *
* ... Read more

Read other 3 answers


I would like to batch replace all files in a directory with a copy of a single file. The file names need to stay the same. Suggestions?


A:Replace all files in directory with copy of single file

May I ask why?

That is exactly what many infections do :-(

Read other 8 answers

Hi excel-macro experts, I am writing a data-compiling macro which does, 1)select folder, 2)open xls files in the folder, 3)select all data for each file (only sheet 1 has data), 4)create a new file in the folder (let's say summary file), 5)paste data selected in the process (3) to the summary file created. With a lot of help from many websites, the following macro has been created. However, there is a PROBLEM that is when the data are pasted, all data were pasted into one column (sorce data of each original file has many columns). I need to avoid this. All I want is pasting the source data to Sheet1 of the summary file with the same number of columns (all source data files has the same number of columns) as the sorcce data has. Your help would be greately appreciated!!!

Function RDB_Last(choice As Integer, rng As Range)

' A choice of 1 = last row.
' A choice of 2 = last column.
' A choice of 3 = last cell.
Dim lrw As Long
Dim lcol As Integer
Select Case choice
Case 1:
On Error Resume Next
RDB_Last = rng.Find(What:="*", _
After:=rng.Cells(1), _
LookAt:=xlPart, _
LookIn:=xlFormulas, _
SearchOrder:=xlByRows, _
SearchDirection:=xlPrevious, _
On Error GoTo 0
Case 2:
On Error Resume Next
RDB_Last = rng.Find(What:="*", _
After:=rng.Cells(1), _
LookAt:=xlPart, _
LookIn:=xlFormulas, _
SearchOrder:=xlByColumns, _
SearchDirection:=xlPrevious, _
On Error GoTo 0
Case 3:
On Error Resume Next
lrw = rng.... Read more

A:Help!: Excel Macro; copy multiple files into one file

Can you put your code in the CODE blocks (there is a button in "Go Advanced" mode)? It'll make it much easier to read - that is, if you've indented your code.

Read other 1 answers

I want to write a batch file that do this for me:

- makes a directory with the "yy.mm.dd.hh.mm" as the directory name,
- copies files and folders from a TEST directory to above destination,
- copies only new (or modified) files from the TEST directory to a separate folder.

Any Idea?

A:a simple batch file for copy files and folders

To create a directory with the date and time as the name, In a batch file use:

set DirName=%date:~-4,4%.%date:~-7,2%.%date:~0,2%.%time:~0,2%.%time:~3,2%
MD \%DirName%

Then in the same batch file use robocopy to copy files to the new directory

robocopy TEST %DirName% /e

you need to add your own paths and read the robocopy help for the right switches you need.
By default Robocopy copies only files that don't exist in the target directory but because you are creating a new directory every time it will copy every thing in TEST

You could use the /A switch which only copies files with the Archive attribute set.

Read other 3 answers

Hello everyone. I recently bought a Toshiba Satellite with Windows 7 installed. I have never used 7, and upon copying files from an external drive to the C: drive I encountered an error stating that one of the folder names was too long. It gave me a couple of options, and I chose "skip." Unfortunately, it doesn't seem that it just skipped the folder. I can't find it anywhere, either on the external drive where I had copied it from or on the C: where I was trying to copy it. If anyone has any idea where these files are I would greatly appreciate it, as I could not find a temporary location or anything else of that sort.

A:Windows 7 File Copy: Can't Find Skipped Files


Try this: In search, type several unique words that would be found in the folders. Maybe the entire title or a name of a special location, etc.

Read other 7 answers

Hi all,

I need a batch file (code) to copy files from last month and zip it for archive. Can somebody help me please?


A:batch file to copy files from last month to archive it.

Read other 8 answers

I mounted a friend's WindowsImageBackup VHD file in Disk Management, did not check Read Only. I assume this means I can write to it.

I'd like to copy all of his files created since the image was made in February into the User folders, then detach the image and reimage to his HD. Is this possible?

A:Copy files into mounted Backup Image VHD file?

Hello Greg,

I would recommend to make a copy of the system image backup before you do that. They can be finicky, and modifying it like that may make it not usable to do a system image recovery with.

Read other 2 answers

I'm running vista on my computer and would like to be able to copy all log files containing the keyword "error" to a folder called "error logs"
thanks in advance

A:How to make a batch file to copy files containing a certain keyword

Welcome to the forum.

use the 'good old msdos' command find

Open command promt en type find /? this will help you see the syntax

Read other 1 answers

Hi guys,

I have a folder with 995 files in it and I'd like to give someone a text file with a list of all these files in it. Is there a way that I can get the command line to send the names of these files to a text file?

I tried navigating to the directory and using the DIR command and, sure enough it gives me a list but I am unable to copy and paste it to a textfile myself for some reason.

Any help would be appreciated.

A:Command Line Prompt - How To Export List of Files to Text File

type this:

DIR > dir.txt

This should save the output of DIR into the text file dir.txt

Read other 5 answers

I have a Windows XP user who can open PDF files on our secondary file server (e.g. \\serverB\shares\marketing\file.pdf) but not from the main server (\\serverA\shares\marketing\file.pdf). Same with copying PDF files. He can
copy them to his desktop. from server B but not from server A. Server A is the one assigned to him because server B is being pre-seeded for DFS and is in a different office anyway.

The problem is only with PDF files. He can open and copy any other files. And it's only on his Windows XP machine. His Windows 7 machine works just fine (he can copy and open PDF files from server A).

The two servers (Windows 2016) are set up identically as far as NTFS permissions. The only difference is that server A is set up in DFS while server B is being pre-seeded before being added to DFS.

DFS namespace type is: domain (Windows Server 2008 mode).

The XP machine had no problem under server A when the DFS namespace type was Server 2000 mode, but I'm not sure that would cause the problem.

Read other answers

I was looking for some files from different folders in a computer so I searched for it using normal windows search and the result has come around 1000 files.

Now when I try to copy all these files and paste it in an external usb, it could not copy because most of the file names are same(though in different paths). Also, I'm not able to check the total sizes of the results.

I wonder then how I can copy all these 1000 files into my usb.

My OS is win xp professional

A:[SOLVED] how to copy all search result files into an USB (even if file names are same

Hello comonforall,

One laborious way to do this would be to temporarily rename them; for instance, if the file is called "Help", rename it to "Help(1)"; then when transferred to their final location, remove the numbers and brackets.

Incidently, what files are you trying to move? If they belong to the Windows XP Operating System; then, transferring them will be useless, because they will not in another location other than the one that they were originally installed.

Post back with the file names.

Kind Regards,

Read other 7 answers

Hi Gurus,

I have many excel files containing similar data.

1. I want to copy specific columns (columns A to U) from all files and paste the consolidated data into another excel file.

2. I also want to copy specific columns (columns C,D,E,G,H,K,L,T,V,W,X,Y) and paste the consolidated data in a different excel.

Please help.

A:Excel macro - copy specific columns from different files to one file

Are all of these source Excel files stored in the same directory? Do they need to be opened and consolidated in any particular order? More details please. If possible please try to provide a sample file with any sensitive data removed.


Read other 1 answers

I require a batch file or free utility that i can redistribute from my web site to other users, (gamers) that will copy the contents of a directory inside their game to a new location and re-name the directory at the same time. Something like this;

Copy "Genesis\Vehicles\truck\diesel\4tonbaker" to "Genesis\Vehicles\truck\diesel\4tonbutcher"

The batch file needs to be run without the need for a command line box being opened, that is, if the user can double click on it or run it with a 'right click' that would be great. Problem there is, I maybe need an exe file not a batch file. The other part of the problem is that the folder to be copied may or may not be in the same location on every PC that runs the file. It may be the case that the 4tonbaker folder is on;
C:\Genesis\Vehicles\truck\diesel\4tonbaker or
D:Genesis\Vehicles\truck\diesel\4tonbaker or even

and I require the end user to have no need to know, just for the directory to be copied and renamed when and where it is found.

If possible I then want the batch file to perform a second task. I want to distribute a folder, lets say it is 4tonbutcher and in that folder there are files lets say doc1.txt, doc2.txt and doc3.txt

On any given users PC 4tonbaker has these same named files but the content is different to the ones in my folder 4tonbutcher, I want to update the newly created folder, 4tonbutcher with the new txt files I d... Read more

A:Batch file or Exe to copy & rename directory and update files

Sounds like you need a windows shell program, I'm not expert enough to help you with this

Here's a nice tutorial:

Win32 Shell Scripting Tutorial

Off topic: this is trivial to do in UNIX, I can whip up a shell script for that in no time...

Read other 1 answers

We've got a file server here in the office on which we have a separate folder for each client. In several of these folders are a document, specific to that client, but with the same name as a similar though not identical document in another client's folder. In other words in client1's folder there may be document.doc and in client2's folder there may be a document.doc. I have need to create a collection of the 400 or so document.doc files in one place but if I were to try to simply copy them from the search result I would get a message asking me if I want to overwrite the files. Is there a way, perhaps from the command line, to copy the files from the search results to the new location and append the name of the folder from which the file is being copied to the file? In other words, client1\document.doc and client2\document.doc will be copied to newfolder\documentclient1.doc and newfolder\documentclient2.doc. Is this something for which I should use robocopy? I've got two computers, one running xp pro sp3 and the other running win 7 pro sp1. The files are on an ms small business server 2011 and will, hopefully, be copied to a file on one of the two local computers from the server. Thanks!


A:copy files from search result and append previous location to file

You cannot copy a file with the same name to a new location without overwriting the previous version. Rename the file before copying it, If you want to keep the original file name in the original folder, then copy it and rename it before moving it. Of course if you rename the file then it will not get updated once changes are made.

Read other 3 answers

I'm currently in the process of copying files back from the cloud in the exact same location where I had them before and now it says that the file name is too long and prompts to see whether I want to skip the file or not. The error message given does not
give the full file name or the path so it is impossible to see which files were copied successfully or not. This never happened with XP! Then afterwards I found that some of the files with long names did copy successfully whereas others didn't. I find this
to be a very user unfriendly process and I'm totally confused! These are critical files and I'm sure I haven't exceeded 260 characters or whatever. This is soOoO frustrating!!


A:file copy error message not sufficient + file name too long will not copy

Hi ,

There is a limit of filename length within Windows Explorer. In the Windows API (with some exceptions discussed in the following paragraphs), the maximum length for a path is MAX_PATH, which
is defined as 260 characters.
The shell and the file system have different requirements. It is possible to create a path with the Windows API that the shell user interface is not able to interpret properly.
This means that your long filename can only be handled at the command prompt level and you cannot drag and drop an illegal length filename within Windows Explorer.

Please simplify your folders and titles.

More information, please check the part of Maximum Path Length Limitation in the link below.
http://msdn.microsoft.com/en-us/library/windows/desktop/aa365247(v=vs.85).aspxTracy Cai
TechNet Community Support

Read other 5 answers


I am new to these forums, but it seems to me this was a good place to go for perplexing questions such as the one I am posing. Google FTW!

Anyway, I recently had a Western Digital hard drive crash due to an unstable connection to the PC. I managed to fiddle round enough with it to where I can connect it to get data from it, though I don't trust the connection to last long. Said connection failure resulted in my having to format the drive in order to have windows properly read it.

I've managed to get a lot of the iportant audio I had stored on the drive using software called GetDataBack. There were a few files thad appeared to have been recovered but that were silent. GetDataBack showed me file sizes which told me said files had ovbiously been broken somehow, though I had copies of these elsewhere so I wasn't too worried.

When it came to retrieving my documents and text files, however, I encountered a very strange thing. GDB shows that all the file sizes are correct (at least on the one's I compared to copies I had floating around) but when I go to copy them and view the on another drive, said files appear to have no text. The file size once on the drive shows me 0KB.

Why would GDB show me the correct file sizes but copy over the same file that appears to be completely void of data? Why would audio files be more in tact than simple .doc and .txt files? Is there any way I can repair/recover these files or are they really devoid of data even ... Read more

A:Solved: Data Recovery - Text files/Word Docs Empty Despite File Sizes

Read other 6 answers

I am a complete newbie when it comes to batch files and batch file software, so apologies in advance.

I've done some research on Google etc but I seem to just be getting more and more confused trying to use various different scripts and programs and reading different info on various websites.

This is what I need...

I have a folder with around 2000 files in it. I want to be able to copy certain files from this folder (normally around 40) and place them in a brand new folder, I want to be able to do this with nothing more than a txt file that has all the file names I need copying in it with every file name on a separate line.

I receive around 10 new txt files each day so you can imagine how tedious it is searching through 2000 files, picking out the 40 I need, 10 times a day everyday.

To make things even more complicated, the txt files I receive don't always have the correct file names in them, maybe there's a misspelling or a word or two missing for some of the names. That's ok when I'm going through picking out the files I need to copy myself because I can normally tell which file is being requested, but I can't see it being so easy for a program or whatever to do, I'm guessing it'll need to have a search feature where it picks out the most likely file.

I'd like it to be as automated as possible. I receive the txt file, make sure each file name is on a separate line then a program or script or whatever goes out and picks out the files (or most likely files f... Read more

A:search multiple files, copy+paste to new folder (batch file software?)

Contact Rent-A-Coder, Elance, or any of the other programming for hire sites. They could knock this out pretty quickly I would think.

Read other 5 answers

Everytime I create a Restore Point, I notice that "Generic Volume Shadow copy" is listed in the Action center.  Should I be concerned?  I don't remember seeing that listing before.  I have a done a couple of System Restore points but none of them show up in the action center as "Generic volume shadow copy."
Driver Management concluded the process to install driver FileRepository\volsnap.inf_amd64_neutral_7499a4fac85b39fc\volsnap.inf for Device Instance ID STORAGE\VOLUMESNAPSHOT\HARDDISKVOLUMESNAPSHOT24 with the following status: 0x0.


A:Generic Volume Shadow Copy listed in Action Center's Reliablity Monitor

FWIW:  http://blog.szynalski.com/2009/11/23/volume-shadow-copy-system-restore/ .

Read other 3 answers

I copied 175GB of files to a different disk. But some would not copy and it said path too long. But how do I know which one they were. All it said was do I want to skip, not skip xyz file. So I deleted them all from the second disk and want to start again

Read other answers

I'm running Windows 7 Professional 64-bit and having the same problem. You can easily resolve the "Hidden File" problem by right clicking on the file, select Properties, and remove the check box next to "Hidden". If you tagged all the photos in a folder, simply select all (ctrl-A) and do the same. It solved the hidden file problem for me without having to show all hidden files.

The problem I'm running into that I can't fix is that even after doing this, Carbonite now recognizes these files as system files and refuses to back them up. Even if you try to manually force Carbonite to back them up, it immediately unselects the check box. Hopefully somebody knows of a solution.

It's weird, because I was tagging photos just a few weeks ago, and didn't have any problems at all. I don't know if there was an update at some point that screwed this all up.


A:Files are listed by Carbonite as system files after adding tag

Welcome to Seven Forums deltaugif.
Have you tried to use the Show Hidden folder to see if Carbonite still does this? Also McAfee has been identified as the reason being files being hidden after an edit.
Maybe someone at Carbonite has a solution? I have no experience with it. I would think a backup program would, well, backup, everything.

Read other 1 answers

Good morning / Good afternoon
As a newbie I am making the first posting on your forum and I hope it is not a silly question.

I received a hard print of an excel spreadsheet with data in 9 columns (2 date formatted and 6 number formatted) of figures from my by bank and I wish 2 use them for further calculation. As I didn't get an electronic file from the bank I scanned the data sheet on the HP Scanner into text files ( rich text, plain text etc) and attempted to import the text into Excel; but I was unsuccessful. Have I attempted the impossible or did I do something wrong ?

If it is possible to do so how should I proceed ?
With thanks, anothernub

A:How 2 import text data into Excel from scanned text file ?

Read other 12 answers

I'm trying to copy a VHD (22g, dynamic I think...)

I tried richcopy. It says copy started, but then stops....

I saw someone mention xcopy /j, to achieve the unbuffered I/O perf. you get with richcopy...

it's running, but no indication as to how long it takes (EDIT: just finished, > 10 mins),

what's the syntax for single files?

Can't you just paste the path into the source?

(starts, and stops... any logs?)

A:how do I copy a BIG single file (using richcopy?) big file copy

Use this command if the VHD is sitting on C:

robocopy "C:\Users\yourName\VHD Folder" "S:\Storage Folder" *.* /COPY:DAT /E

Change yourname and replace VHD Folder with the name of the folder where the VHD resides. S:\Storage Folder is where you want to store it.

Read other 1 answers

I have a project where I need to search a large amount of text files on my home PC. I recently upgraded from Windows XP to Windows 7. My research indicated this feature was available in Windows 7.

If you do a search in Windows XP, you get a bunch of fields. You can pick to search for text INSIDE the particular sub folder structure.

I have found this feature in Windows 7, but it is different. I have tried using wild cards but it does not seem to work properly.

Thanks for any advice, if you need further assistance, I could make a video to show the issue.

A:Searching a bunch of text files for a particular text string

I don't have Windows 7. So I can't comment on how effective the search feature is. But I know I would not be able to function without the tool Agent Ransack.

It's a free utility, see if it will work for your needs: http://www.softpedia.com/reviews/windows/Agent-Ransack-Review-60432.shtml

Read other 10 answers


First, I apologize for this post being so long.

I'm running windows XP w/Service Pack 3 and all critical updates.
I'm having a strange problem with text files.
The text I enter into the file gets mysteriously rearranged.

I was making a numbered list in notepad.

Like this (just as an example):
1. Text on the first line.

2. Text on the second line.

3. Text on the third line.

4. Text on the fourth line.

5. Text on the fifth line.
Nothing fancy just entering the info manually.
the list was numbered up to line 190.
I went back to look over the list and I noticed that
it was numbered wrong. Some numbers were skipped.
I just figured I misnumbered it but after I fixed the
numbering it kept happening.

I copied and pasted the list from notepad into another text editing
program and it kept happening in the other program too.
So to test it I wrote a few more lines to see if it would mess it
up again.

I wrote 5 more lines in the new program
(numbering here is just an example):
10. Text on the tenth line.

11. Text on the eleventh line.

12. Text on the twelfth line.

13. Text on the thirteenth line.

14. Text on the fourteenth line.
I left notepad open while I looked over to watch something on tv for
a few minutes and when I looked back at the computer the thing had
renumbered itself again. The last two lines had switched places and
were now both numbered the same number.
It looked like this:

10. Text on the tenth line.

11. Text on the Eleventh line.
... Read more

A:Problem with text files rearranging the text I enter.

Hi Phil -The one thing missing is either a Screen shot or a Copy / Paste of how the text actually looks -Has the above been done on the same computer, or another computer ???It looked like this: << Is a bit hard to diagnose at times without seeing the problem that you mention -Do a document and take a screen shot as soon as you finish ~ Let it sit for 5 minutes ~ Take another screen shot You only need to enter silly text but it is a recorded text -Thank You -

Read other 5 answers