Saving Files opened in IE through VB

I create an instance of Internet Explorer in VB6, and use it to point to a link which activates a filedownload. The file downloaded is a .csv file that is opened in the Internet Explorer window. I want the file to be automatically saved to disk with the path coded from within VB and then to be able to open it from VB. The file is automatically saved in the "temporary Internet files" folder, but VB doesn't seem to be able to open it.

Is there anybody that can help me

Thanks