• Subject: Extrating Daily File
  • Author: Schwimms
  • Date: 01 Jul
  • References:
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.
01 JulExtrating Daily File.Schwimms
02 Jul\ Re: Extrating Daily File.Michael Bauer [MVP - ...
All times are in (US) Eastern Daylight Time (GMT -4:00)