[RESOLVED] wait until execute

how can i delay the function
insword

until the the previous shell executes

VB Code:

'open command prompt to run Python script
 Open Apath & "dos.bat" For Output As #1
    Print #1, "cd C:\python24"
    Print #1, "buckwalter2unicode.py -i C:\newfile.txt -o C:\newoutfile.txt -E mbcs"
    Close #1
    Shell Apath & "dos.bat"
   
 
 insword

Won't this be finished when "C:\newoutfile.txt" is created? If so, do it in a Do Loop.

Yes it will finished when "C:\newoutfile.txt" is created

OK
how can i check its existing before opening it in the function insword
if file exist then open it


do while "newoutfile.txt" exist
Open "C:\buckwalter_morphan_1\data\newoutfile.txt" For Input As #ff
tmp = Split(Input(LOF(1), 1), vbCrLf)
loop

God no!

Check for file existence with the DIR command

VB Code:

Do While Dir("Yourfilename")=""
   DoEvents
Loop

thanks randem :blush:


but this didn't work because
the shell command will write to the file newoutfile.txt
and the do while will execute the function just after creation and befor finish writing

which will give me unwanted output :confused:

so how can i start insword after writing to file

Well, after you detect the file then you attempt to gain exclusive access.

Will the file be a specific size when created?

Dear om-yousif,
Have a look at this thread

this might help //

http://www.vbforums.com/showpost.php...4&postcount=17
http://www.vbforums.com/showthread.p...98#post2587998

thanks danasegarane
its exactlly what i need
but how can i hide the command prompt window
i don't want it to be visible to the user

Shell it with vbAppWinStyle set to vbHide.

???? gavio ?????
:confused:
i'm new in VB
what did you say :ehh:

Hi om-yousif...
I think U can write like this:

VB Code:

' ShellAndWait Apath & "dos.bat"
    Shell Apath & "dos.bat", vbHide

:wave:

Why not just ShellandWait???

Thanks everyone i used shellandwait

thanks again for your help :)