Dear All

I would like to check whether is it possible to run DOS commands i
Excel...?

Currently, I have to copy many files every month using DOS. For eg. DO
command = copy 123aug.txt 123sep.txt

In a nutshell, I would need to make a copy of a specific file and the
rename it as the current month so that I will have the file for ever
month...

I thought of writing a code to open the file and then do a "save as"..
But does anyone know how I can do the same thing but without opening th
file... because there are different files (text) and their delimiter
are different...

Hope you guys understand my problem... I will really appreciate an
suggestions..

Cheer

--
hc
-----------------------------------------------------------------------
hce's Profile: http://www.excelforum.com/member.php...nfo&userid=351
View this thread: http://www.excelforum.com/showthread.php?threadid=26838