Code Doesn't Wait!

[Guest]

Window NT; Excel 97
1. I have a VBA procedure that uses DOS to create a directory listing file,
then it accesses the file. But, the code "beats" DOS, and tries to access
the file before DOS finishes creating it.
How do I get the code to wait for DOS to finish?

2. This same dilemma applies to having a VBA procedure open a workbook,
execute several actions, then close the file. The procedure beats itself and
closes the workbook before it's finished making the changes.
How do I get the code to wait for itself to finish before closing?

Thanks,
Trent Argante
[TPA.J(67)]

 

[Dave Patrick]

Give this a go or look at the Run method of VBScript.

http://support.microsoft.com/kb/q129796/

--
Regards,

Dave Patrick ....Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
http://www.microsoft.com/protect

:
| Window NT; Excel 97
| 1. I have a VBA procedure that uses DOS to create a directory listing
file,
| then it accesses the file. But, the code "beats" DOS, and tries to access
| the file before DOS finishes creating it.
| How do I get the code to wait for DOS to finish?
|
| 2. This same dilemma applies to having a VBA procedure open a workbook,
| execute several actions, then close the file. The procedure beats itself
and
| closes the workbook before it's finished making the changes.
| How do I get the code to wait for itself to finish before closing?
|
| Thanks,
| Trent Argante
| [TPA.J(67)]

 

[Guest]

Dave, this article answered the first dilemma, so thank you.
But, I still need a solution for the second

 

[Dave Patrick]

Without looking at it I have no idea.

--
Regards,

Dave Patrick ....Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
http://www.microsoft.com/protect

:
| Dave, this article answered the first dilemma, so thank you.
| But, I still need a solution for the second

 

[Guest]

I was wrong. It didn't work for the first either. The code example in the
article worked instead of using shell "notepad.exe, but not for shell "dir >
listing.txt".
Any ideas?

 

[Dave Patrick]

These may help if you don't want to use a scripting solution.

http://www.freevbcode.com/ShowCode.Asp?ID=99
http://www.freevbcode.com/ShowCode.Asp?ID=99

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/script56/html/wsmthrun.asp

--
Regards,

Dave Patrick ....Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
http://www.microsoft.com/protect

:
|I was wrong. It didn't work for the first either. The code example in the
| article worked instead of using shell "notepad.exe, but not for shell "dir| listing.txt".
| Any ideas?