move files

I need a script that will check a given directory for .pdf and .xls
files that have exactly the same name. If a pair of .pdf and .xls
files with the same name are found, the script should move the .xls
file to another directory.

Any guidance would be appreciated.

You can easily do this with a humble batch file (see below). If you prefer a
VB Script then you should download the help file script56.chm from the
Microsoft site. It contains detailed examples for the "move" method of the
File System Object.

@echo off
set Source=D:\Fri 23
set Target=D:\Destination
if not exist "%Source%" echo Folder "%Source%" not found.
if not exist "%Target%" md "%Target%"
pushd "%Source%"
for %%a in (*.xls) do if exist "%%~na.pdf" move /Y "%%a" "%Target%"
popd

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode test 33Switch to Hybrid Mode Switch to Threaded Mode

1 25th October 16:22 doug howell External User Posts: 1	move files I need a script that will check a given directory for .pdf and .xls files that have exactly the same name. If a pair of .pdf and .xls files with the same name are found, the script should move the .xls file to another directory. Any guidance would be appreciated.