M
MarkS
Hi,
I use this to get some file data
' Get directory,filename,date and size
x = Shell("cmd.exe /c dir /Tw/S " & sPath & "*." & LCase(sFileExtension) &
" > " & ThisWorkbook.Path & "\Directory.csv", 1)
what i need to do is now wait until it is finished before the rest of the
code runs
Thanks MarkS
I use this to get some file data
' Get directory,filename,date and size
x = Shell("cmd.exe /c dir /Tw/S " & sPath & "*." & LCase(sFileExtension) &
" > " & ThisWorkbook.Path & "\Directory.csv", 1)
what i need to do is now wait until it is finished before the rest of the
code runs
Thanks MarkS