Solved: download complete

[av8tordude]

Is it possible to determine (via VBA) when a download is complete?

I'm using the code below to download a file. Currently, I'm using a userform to select the downloaded file to accomplish a task and I would like to eliminate this step in my code to automatically run my code to open the file once the file is downloaded.

Thanks

Sub sDownloadHTTP(strURL As String)
    strURL = StrConv(strURL, vbUnicode)
    DoFileDownload (strURL)
End Sub

sDownloadHTTP "http://www.mysite.com/myfile.zip"