Hi,

I have a bat file which renames the files in a folder. I am unable to
run this batch file from excel macros. Could anybody help me on this.

Thanks,
Santosh

Try:

shell(PathAndFilenameOfYourBatFile)

Cheers,
Jason Lepack

bhs wrote:
Hi,

I have a bat file which renames the files in a folder. I am unable to
run this batch file from excel macros. Could anybody help me on this.

Thanks,
Santosh

Hi Jason,

I tried that but its not working. When just double click the bat file,
its working but not through excel macros.

Thanks,
santosh

Mike,

Even this does not work.
what i noticed was, when run this the cmd prompt is in "C:\Documents
and Settings\bhs\My Documents" but my batch file is in C:\.
I used the syntax like this :
Shell Environ("comspec") & " /k C:\ravinu.bat", vbNormalFocus
Where /k helped me freezing the cmd window.

Now i need to get the cmd prompt to "C:" and then execute the batch
file. Can you help me on this.

Thanks,
Santosh

Just a word of caution. Execution of any other code in your workbook will
not
wait until a shell command has completed it will continue.

You can make it wait. See http://www.cpearson.com/excel/shellandwait.htm .
This has two procedures: ShellAndWaitSimple, which just waits for the
process to end, just like every other ShellAndWait routine out there, and
ShellAndWaitEnhanced that lets you display messages to the user as the
shell'd program runs.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
(email address is on the web site)


"Mike" wrote in message
...
bhs,

I'm really not now sure what your question is but if you simply want a
command prompt the syntax is

result = Shell("cmd", 1)

Just a word of caution. Execution of any other code in your workbook wil
not
wait until a shell command has completed it will continue.

Mike



"bhs" wrote:

Mike,

Even this does not work.
what i noticed was, when run this the cmd prompt is in "C:\Documents
and Settings\bhs\My Documents" but my batch file is in C:\.
I used the syntax like this :
Shell Environ("comspec") & " /k C:\ravinu.bat", vbNormalFocus
Where /k helped me freezing the cmd window.

Now i need to get the cmd prompt to "C:" and then execute the batch
file. Can you help me on this.

Thanks,
Santosh