ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Run DOS command (https://www.excelbanter.com/excel-programming/419645-run-dos-command.html)

KalliKay

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

joel

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



All times are GMT +1. The time now is 05:45 PM.

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