How can I retrieve data from zip file into excel?

  • Thread starter Thread starter Eric
  • Start date Start date
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"
 
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)
 
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
 
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
 
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 import external data into excel? 2
How to retrieve the value? 3
How to retrieve the sheet name? 2
Import data from zip file through Internet 3
How to retrieve data from other filename? 1
How to retrieve the name of the excel file into spreadsheet? 3

Back
Top