View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_7_] Bob Phillips[_7_] is offline
external usenet poster
 
Posts: 1,120
Default Run a batch file from Excel

You don't need DOS, you can do it from VBA

Name oldpathname As newpathname

--
HTH

Bob Phillips

"Tempy" wrote in message
...
Good morning,

Is it possible to run a Dos batch file with code from Excel ?

I save a file as a ".PRN" with excel and must then change it to ".DAT"
and want to do this with my code & not have to go to the file right
click and then "change name" and put in ".DAT".
It needs to be ".DAT" so that it can be used in SAP.

Thanks in advance.

Tempy

*** Sent via Developersdex http://www.developersdex.com ***