Extrating Daily File

Hi!

I have a file that comes to me daily in outlook called "ACT Daily.zip" and
what I need to do is extract the file (extracts as an excel file) delete and
clean up some of the data and then save two of the five tabs into a folder
overwriting yesterday's file. The files are saved as text. I have the code to
delete and clean up the data and save it as a text.

What I need is the code to find the current "ACT Daily.zip" file and extract
it and open the excel file.

Any help.

You might google for any library that is able to extract files from the zip.
I'm sure there's freeware available.

If you have the xls extracted, you may open it with the objects exposed by
Excel. Add a reference to Excel to your project, open the object browser
(f2), switch from <All libraries> to Excel, and see what's available. For
opening a workbook see the Workbooks.Open function.

--
Best regards
Michael Bauer - MVP Outlook

: VBOffice Reporter for Data Analysis & Reporting
: Outlook Categories? Category Manager Is Your Tool:
: <http://www.vboffice.net/product.html?pub=6&lang=en>


Am Tue, 1 Jul 2008 06:59:00 -0700 schrieb Schwimms:

> Hi!
>
> I have a file that comes to me daily in outlook called "ACT Daily.zip" and
> what I need to do is extract the file (extracts as an excel file) delete
and
> clean up some of the data and then save two of the five tabs into a folder
> overwriting yesterday's file. The files are saved as text. I have the code
to
> delete and clean up the data and save it as a text.
>
> What I need is the code to find the current "ACT Daily.zip" file and
extract
> it and open the excel file.
>
> Any help.