As per my usual, I have no idea where to begin. What I need to do (when using the attached dummy files) is to provide an option that will zip multiple files after filtering the results within excel. As you can see from the attached xlsm, the names have links to word documents. Those word documents are the files that need to be zipped up. The whole process should be:
1. Filter my results given the criteria that I choose.
2. Make a decision as to whether or not I need to zip the files up, if I do, I click a macro button that takes only the filtered results and zips up the files that are only associated with those results.
OSs it will be used on:
-Mostly Windows XP
-Windows Vista 32 and 64 on the rare occasions.
How to use current filter with attached file:
-Simply Click the filter button that's located to the right of the data (around column H)
-Select a criteria and click "Add to Criteria". For simplicity sake, keep the criteria simple, there are only 7 names. So basically just filter ASA or something The real file has a LOT of rows of data.
-Finally click the Filter button that's below the Add to Criteria button
Attachment includes:
-A zip file that includes:
--A directory folder that has blank word documents that represent resumes and cover letters.
--An excel macro worksheet that has data including fake names that link to the files in the directory folder.
If you have any questions I'll responded pretty quickly.
One last final question:
Are there any books that are meant for the dumb and busy people like me? I want to learn, but my focus level is pretty low due to a lot of distractions and family drama. I swear they have a sixth sense in just KNOWING when I'm trying to learn ANYTHING.
I PRAISE THESE FORUMS AND ALL WHO CONTRIBUTE
sigh, might be years before I can contribute to these forums