Unzip with vba - cut text in a txt file

[diegomarino]

Hi, i'd like to use vba to unzip compressed files. I found just few old stuff in internet, i'm wondering if there is a not to complex way to achieve that.



more, the zipped file is a txt file which text i'd like to cut from beginning till a word.
thanks

[Micron]

I asked my buddy Barney Google and got over a million hits so it seems you're not the first to ask. Here's one result
https://stackoverflow.com/questions/...-all-for-any-d

EDIT
As for the cutting up to a word, you'll need a reference to Microsoft Scripting Runtime library, or you might get away with just using Dir object (I can't remember which library that one belongs to). I have never used either to copy part of a text file though.

[diegomarino]

thanks, i missed this one i have to remember to use stackoverflow.
actually the file is a txt, but this is the easy part of the job