VBA code to transfer the excel file into another open workbook

Hi Masters,

I badly need your help in the data that extracted from website.

I got the codes working already except how to transfer the exported data in an open workbook where to copy the data.

In pic1 you will an excel export button. If manually done it will export the data in excel format.
This is the code I used to open the file but it will ask me to click open and yes button as seen in pic2 & pic3.

[ieApp.Navigate "http://www.intexpress.com/BizDesk/excelExport.aspx?new=excel"][/HTML]
pic1.jpg



In pic2, it will open a new internet explorer where you will have the option to save the file but I prefer to open only the file.

pic2.jpg


In pic3 you will be prompted to click twice so file will be open.
pic3.jpg


The target is to be able to transfer the exported data into this workbook "Export Daily Shipment.xslm" with sheet name "Data - All Details".
Please help me how to code this.


Thanks :D

any help would be much appreciated