Hi
I cant work out how to import the contents of a Zip file into an excel sheet, I can do it if I save the data that is contained in the zip file of as a csv but it is easier for me to pull the data with in the Zip file and would save a lot of time if I could just import from the Zip.
Any help would be appreciated.
Thanks
You need to extract the files before you can open/import them through VBA. The extraction, opening and importing can all be done within VBA, but there is not direct way to pull info from within an archived file without first extracting it.
This is how to get the zip saved down.
http://www.excelforum.com/excel-prog...ml#post3715209
Last edited by Hawkeye16; 07-07-2014 at 04:35 AM.
Despite the high cost of living, it remains very popular.
Don't forget to mark threads SOLVED when you get an answer and rep all the geniouses that helped you today!
Ok Thanks
VBA is a bit above me at the moment
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks