How can I retrieve data from zip file into excel?

R

Ron de Bruin

Hi Eric

I have unzip code on my site for WinZip and the default Windows Zip program

See this section on my site
"Zip (compress) file or folder with VBA code"
 
E

Eric

Thank you very much for your suggestions
There are 3 choices, could you please give any suggestions which one I
should choose for retrieving data into Excel from
http://pitrading.com/free_eod_data/S.zip?
Thank you very much for any suggestions
Eric

Zip file or files with the default Windows XP zip program (VBA)
WinZip : Zip the Activeworkbook, File or Files with (VBA)
WinZip : Unzip to a specific folder with (VBA)
 
R

Ron de Bruin

I see it is only one txt file

Why not unzip the txt file on your system and use File>Open in Excel to open the file.
The text import wizord will help you when you use File>Open
 
E

Eric

I would like to retrieve the data directly from Excel through the web link,
rather than download and unzip the file for retrieving data, which require a
lot of manual process everyday. I would like to run a macro and retrieve the
data into excel automatically, which will reduce the workload.
Do you have any suggestions?
Thank you for any suggestioins
Eric
 
R

Ron de Bruin

Sorry I never test it with a download only with mail.
Use Google to search for a solution
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to load and import zip file using Macro? 1
How to retrieve the yahoo symbols into excel? 1
How to retrieve the value? 3
Create a dynamic master file 1
How to import external data into excel? 2
How to retrieve the sheet name? 2
How to retrieve the value within string? 11
Import data from zip file through Internet 3

Top