This may be a double Post, please forgive me, the system seemed to fail on
the first attempt.
First of all let me thank yourself and Doug Steel for the extensive code. It
may be in fact more than I need. After playing with some code, as I see it, I
may be importing the Excel file into a table and then creating & cycling thru
a recordset to look for a specific Code and then select the Filename to Add
to a specific Zip file, then go to the next record and continue...
So my question is; "How do I execute the Pkzip command line from within
VBA?" The is is what the Pkzip Manual says has to be executed.
pkzipc -add ABC.zip filenam.doc
But i don't understand how to do that from VBA.
Am i making any sense?
Thanks Guys!!!!

"Albert D. Kallal" wrote:

"Brad@Cibc" wrote in message
...
Thanks so much Albert!
However, as i understand it, your code doesn't allow selection of multiple
files.

Well, I just don't have a UI setup, but can pass it wild cards and it will
work fine. So, you not limited to just one file.

It really comes down to how the selection of files is going to occur
here....



--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada