ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Executing dos command (https://www.excelbanter.com/excel-programming/411685-executing-dos-command.html)

Furqi

Executing dos command
 
I need to create a link in excel cell which can execute set of dos commands.
Can anybody help me out?

Rick Rothstein \(MVP - VB\)[_2021_]

Executing dos command
 
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


"Furqi" wrote in message
...
I need to create a link in excel cell which can execute set of dos
commands.
Can anybody help me out?



Mike H

Executing dos command
 
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

"Furqi" wrote:

I need to create a link in excel cell which can execute set of dos commands.
Can anybody help me out?



All times are GMT +1. The time now is 10:29 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com