Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Programming / May 2008

Tip: Looking for answers? Try searching our database.

Executing dos command

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Furqi - 29 May 2008 09:41 GMT
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) - 29 May 2008 09:48 GMT
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

>I need to create a link in excel cell which can execute set of dos
>commands.
> Can anybody help me out?
Mike H - 29 May 2008 09:57 GMT
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

> I need to create a link in excel cell which can execute set of dos commands.
> Can anybody help me out?
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.