View Single Post
  #1  
Old July 1st 08, 02:59 PM posted to microsoft.public.outlook.program_vba
Schwimms
external usenet poster
 
Posts: 1
Default 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.
Ads