DOS output

A

Anupam Soral

Is there a way thru which we can run DOS command thru VBA programming in Excel
 
M

Mike H

Hi,

One way would be to open Notepad and put your Dos commands in a file and
save it as (say) mydos.cmd

Then in Excel try
mydosresponse = Shell("C:\MyDos.cmd", 1)

Have a look at Shell help for what you can do with the second numeric
argument.

Mike
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel spreadsheet to Word document 1
Page number within a worksheet 1
page number display 1
How write into text file at first and last line with excel vba? 3
Object Heirarchy Chart 1
VBA - ThisWorkbook 4
VBA Loop Code 5
can we copy the code from the addin to excel workbook 1

Top