Problem with Shell function runs other programs asynchronous
Problem with Shell function runs other programs asynchronous
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Problem with Shell function runs other programs asynchronous

  1. #1
    New Member
    Join Date
    Apr 2002
    Posts
    15
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    I have two shell commands right after each other

    To make things simple lets say the old.txt is a static file that doesn’t change and is made already

    The first shell with the old.txt info when it runs it makes the old2.txt
    Shell "Command.com < old.txt" ‘This line runs and it makes old2.txt file
    Shell "Command.com < old2.txt"

    The Problem is excel run the command.com Then it runs the command.comBut the old2.txt hasn’t been made yet


    What works kind of which I don’t want to use is putting this next couple statements between the two shell “command.com”
    Making a for aloop = 1 to 10000000
    Next a

    What I want to do is change the default of the shell function to have it wait until the shell “command.com” is finished
    I think I found on the msn some info on how to do it but I haven’t been able to find that info again
    Or maybe if was for a different language
    I tried what I remembered it said but I didn’t have any luck


    This is some text from help in excel
    Note By default, the Shell function runs other programs asynchronously. This means that a program started with Shell might not finish executing before the statements following the Shell function are executed.

    Thanks
    Barry

  2. #2
    MrExcel MVP Ivan F Moala's Avatar
    Join Date
    Feb 2002
    Location
    Auckland, New Zealand
    Posts
    4,209
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Have a look here
    http://www.mrexcel.com/board/viewtop...c=5236&forum=2

    Look @ BrettVBA answer....this answer is more
    suited to your needs.
    Post if further help required.

    Kind Regards,
    Ivan F Moala From the City of Sails

  3. #3
    New Member
    Join Date
    Apr 2002
    Posts
    15
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    Thanks
    for pointing out BrettVBA answer

    I quicky looked at his answer before but kind got confused with it
    so i didn't understand what all it was doing
    but since you pointed it out i read it closer and tried it and it looks like a good solution to my problem
    Thanks
    Barry
    Also thanks to BrettVBA for posting his message and code

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com