LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 4
Default Shell Command read Range and Loop

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
VBA shell command - issues... JWM6[_2_] Excel Programming 7 April 19th 06 10:59 PM
Shell Command JOHN Excel Programming 1 November 17th 04 10:39 AM
Shell command MAx Excel Programming 2 June 4th 04 04:11 PM
xp shell command using vba Sudhendra Excel Programming 2 February 16th 04 05:56 AM
SHELL command Robin Clay[_3_] Excel Programming 3 October 17th 03 02:50 PM


All times are GMT +1. The time now is 02:50 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"