Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have a table in Excel that is queried from Access and contains three numbers:
Nest# Time WC 3004 312 MC3 3005 100 MC3 5214 213 MC4 1254 111 MC2 What I want to do is run a shell command and loop through the table. I cannot get the VBA Shell to read the Cells and I am not sure to Loop it till A is null or empty. Sub RunYourProgram() Dim RetVal As Long On Error Resume Next RetVal = ShellExecute(0, "open", "F:\iMFG\IMrp\iMrp.exe", "/c" & Range("C1") & " /e LV /w F:\iMFG\AccuFab\iLaser\ /t" & Range("B1") & Range("A1"), _ "F:\iMFG\IMrp\", SW_SHOW) End Sub Any help would be great, Greg |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
VBA shell command - issues... | Excel Programming | |||
Shell Command | Excel Programming | |||
Shell command | Excel Programming | |||
xp shell command using vba | Excel Programming | |||
SHELL command | Excel Programming |