Using a bat file to map network drives

[GSMike]

I have code that writes a batch file and then shells the file in:

sub blahblah
dim fso as new filesystemobject, ts as textstream
set ts=fso.createtextfile("c:\temp\myfile.bat")
ts.writeline "net use m: \\myserver\myshare"
ts.close
shell("c:\temp\myfile.bat",vbhide)
fso.deletefile "c:\temp\myfile.bat"
end sub

Everything works fine as long as I EXCLUDE the line where I delete the text file I just created.
Apparently, the executing code isn't waiting for the batch file to finish its job before it proceeds to the next line of code, and it deletes the batch file before it executes??
Is there a way to have the VB code wait (??) for the batch file to finish executing before it proceeds on the its own next line??
Obviously, I could just leave the file I created there, but I guess I'm kind of complusive about cleaning up after myself.
Thanking you in advance, Mike K

 

[Guest_imported]

check this out. it has worked very well for me in many applications

http://www.scottandmichelle.net/scott/code/index2.mv?codenum=069

 

[GSMike]

that looks right on...THANKS!!!...I'll try it and give you a report back! Mike K