[RESOLVED] wait until execute

[om-yousif]

how can i delay the function
insword

until the the previous shell executes

'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

[gavio]

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

[om-yousif]

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

[randem]

God no!

Check for file existence with the DIR command

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

[om-yousif]

thanks randem


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

so how can i start insword after writing to file

[randem]

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

Will the file be a specific size when created?

[danasegarane]

Dear om-yousif,
Have a look at this thread

[rory]

this might help //

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

[om-yousif]

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

[gavio]

Shell it with vbAppWinStyle set to vbHide.

[om-yousif]

???? gavio ?????

i'm new in VB
what did you say

[bodoora]

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

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

[randem]

Why not just ShellandWait???

[om-yousif]

Thanks everyone i used shellandwait

thanks again for your help