Instructing Dos to take a formula from a cell within excel and excecuteing it

[proditneg]

Hi,

I am having a difficulty on writing a command within excel so that a set of formulas on a given column is excecuted in dos.

this is the formula which i want to be excecuted from within excel:

md "D:\location\folder name " & xcopy "S:\location\filename" "D:\location\folder name" & Rename "D:\location\filename" "new filename"

this formula runs accros the column depending on the number of entries.

If anyone can advice that would be extremley helpful as im stuck at this point.

Cheers

 

[Ruddles]

I would not imagine the difference to be noticeable, even for many or large files. Unless your program takes a very long time to execute, I wouldn't be concerned.

 

[proditneg]

Tried the new code and it works considerably faster with large files 100mb+..
Thanks for your help guys..