If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Wanting to grab group of files and PkZip them.
I have an excel file that has two columns, Code and Filename.
i.e. CODE Filename Abc 123456.txt Abc 123457.txt Def 123458.txt Def 123459.txt Etc… I would like to be able to select all files with a specific Code and have them zipped into a file that is named the same as the Code. i.e. Abc.zip would contain 123456.txt & 123457.txt AND Def.zip would contain 123458.txt & 123459.txt The file names are actually quite random but they are associated with specific codes according to this Excel file. I am creating an Access form that will allow users to browse to the Excel file and would like to be able to code this form to perform the above operation automatically. Is this possible in VBA? We are using Access 2003 & Pkzip Any ideas? Regards Brad |
Thread Tools | |
Display Modes | |
|
|