Thread: Run DOS command
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
joel joel is offline
external usenet poster
 
Posts: 9,101
Default Run DOS command

You simply need to put the command into a shell function

shell("command String")

The only problem you may have is with the double quote. You can use chr(34)
for the double quote.

String1 = "Abc"
String2 = "Def"

String3 = String1 & chr(34) & String2



"KalliKay" wrote:

I have a command in one cell in an excel document that I need to run from
DOS. I need help figuring out how to do this?

R:\TL\Apps\Apps\shortcut.exe /F:R:\TL\Data\ImageLinks\1125893.lnk /A:C
/T:"https://imagesilo.com/SearchURL.ASP?UserName=URL-LOGINPassword=TL01&EntID=xxxx&ProjID=9&IndexFields =Owner Entity|Property|Property Name|Lease

Any help would be greatly appreciated. Thanks

KK