Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Run DOS command
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
command code ( GOTO command) in formula | New Users to Excel | |||
Userform Command Button not available until another command buttonhas been used | Excel Programming | |||
Pivot Table Error Message - "Command Text not set for command obje | Excel Discussion (Misc queries) | |||
Wanting to Create A Command Button Command | Excel Programming | |||
Excel to load COMMAND and type a Run Command? | Excel Programming |