This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
I would like to load the following file within zip into excel
File: 20100820_1_dtop_f_hkcc_fut_dtl_hsi.rpt
http://www.hkex.com.hk/eng/stat/dmstat/OI/DTOP_F_20100820.zip
Does anyone have any suggestions?
Thank everyone very much for any suggestions
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Once I unzip it, I would like to load text from rpt file into excel
File: 20100820_1_dtop_f_hkcc_fut_dtl_hsi.rpt
Do you have any suggestions on how to code the macro to load all the texts within this rpt file under specific directory into excel?
Thank everyone very much for any suggestions
I would like to create a macro to perform unzipped and insert function into Excel.
Do you have any suggestions?
Thank everyone very much for any suggestions
Why not just extract the data from the ZIP'ed file and load or import as usual?
gsnu201005