Opening data files within zip files automatically

Hi All,

There is data being automatically stored in text file of the same name, within unique zip files, on a directory.

So I am trying to write a macro that will do essentially two things

1. Look into a directory, and find any new zip file, look into it and open a notepad document called data.txt.

2. Open the notepad file and convert it to tabular form.

the second I can do, but I'm not aware of the first. Can anyone help please?

ok...figured out how to extract notepads from zip files.....

how would you merge data from multiple files and save them into one