Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Run a Batch file with variables
Hi I want to be able to open an application from with-in excel which will then open a job withing the app. Example Batch file (Run.bat) : "C:\Program Files\IequalsP\pressing matters cygnus\cygnus.exe" %1 %1 = D12345 ( a job number ) so in excel something like =HYPERLINK("Run.bat D12345","Open Job") -- Stuartf ------------------------------------------------------------------------ Stuartf's Profile: http://www.excelforum.com/member.php...o&userid=34535 View this thread: http://www.excelforum.com/showthread...hreadid=545091 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Run a Batch file with variables
This old code, run from a regular module in Excel, will open AutoCAD and
then the file called acadtest.dwg........perhaps it will help point the way to what you want to do.... Sub StartAutocad() VBA.Shell "c:\program files\autocad lt 2000i\aclt.exe c:\acadtest1.dwg", vbMaximizedFocus Dim oAutoCad As Object Set oAutoCad = GetObject("c:\acadtest1.dwg") oAutoCad.sendcommand "filedia" & Chr(32) & "0" & Chr(32) oAutoCad.sendcommand "script" & vbCr & "c:\Program Files\Scriptsheets\Script.scr" & vbCr & vbCr oAutoCad.sendcommand "filedia" & Chr(32) & "1" & Chr(32) End Sub Vaya con Dios, Chuck, CABGx3 "Stuartf" wrote: Hi I want to be able to open an application from with-in excel which will then open a job withing the app. Example Batch file (Run.bat) : "C:\Program Files\IequalsP\pressing matters cygnus\cygnus.exe" %1 %1 = D12345 ( a job number ) so in excel something like =HYPERLINK("Run.bat D12345","Open Job") -- Stuartf ------------------------------------------------------------------------ Stuartf's Profile: http://www.excelforum.com/member.php...o&userid=34535 View this thread: http://www.excelforum.com/showthread...hreadid=545091 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
disc full, saved to temp. file | Excel Discussion (Misc queries) | |||
Pasword protected Excel file encrypted, how do I read this file? | Excel Discussion (Misc queries) | |||
Weird File Open/Save As Behavior | Excel Discussion (Misc queries) | |||
Links picking up values from an older version of linked file | Links and Linking in Excel | |||
cannot open excel file, please help!!! | Excel Discussion (Misc queries) |