Executing dos command

  • Thread starter Thread starter Furqi
  • Start date Start date
F

Furqi

I need to create a link in excel cell which can execute set of dos commands.
Can anybody help me out?
 
You should be able to use the Shell statement for that, but the DOS session
will not be able to pass back information to you (well, you could redirect
it out to a file and read it back in, but that is sort of messy). I'm
willing to bet if you tell us the DOS commands you want to execute, someone
here should be able to give you a VBA equivalent to execute.

Rick
 
Hi,

Use Notepad to put your set of Dos commands in a file and save as (say)

myfile.bat

and create a hyperlink to it in a cell on your worksheet. Clicking the
hyperlink will execute them.

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

need help creating a Batch-File 1
DOS..BAT VB Progamming problem 3
Command Line to Open/Close an Excel Files , macro print it in a designated Folder 1
DOS output 1
Stop Command Question 4
SQLServer 2017 exec xp_cmdshell 'dir Y:\*.*/s' command fails 3
Run DOS command 1
shell function 4

Back
Top