Zipping file from excel

hi,

I have a task of zipping many files and the path of these files are specified in a excel file too. Is there any way of creating a macro in excel to zip the files specified in the path with a name specified in the excel and encrypt if possible.

Tks
MS

Hello mohanss82,

Here is a macro to Zip a file using VBA. This includes error handling.

Please Login or Register  to view this content.

Example of using the macro

Please Login or Register  to view this content.

Adding the Macro
1. Copy the macro above pressing the keys CTRL+C
2. Open your workbook
3. Press the keys ALT+F11 to open the Visual Basic Editor
4. Press the keys ALT+I to activate the Insert menu
5. Press M to insert a Standard Module
6. Paste the code by pressing the keys CTRL+V
7. Make any custom changes to the macro if needed at this time.
8. Save the Macro by pressing the keys CTRL+S
9. Press the keys ALT+Q to exit the Editor, and return to Excel.

Sincerely,
Leith Ross

Hi Leith Ross,

Thanks for the prompt response.

below is the format I use, tell me where the macro needs to edited to suit my below format.

Sl.No Name Path Zip Name Password
1 Mohan C:\Temp Test 123

Tks
MS

Hello mohanss82,

I don't follow your method for creating the path for the file to be zipped. Will you be reading file names from a worksheet? What else is being added to the file name? Do you want to password protect the Zip file?

Sincerely,
Leith Ross

Yes sir..

I want the files to be ziped using the names in excel and encrypt with the passwod given in the same excel.

Is this possible

Tks
MS

Hello mohanss82,

Yes. I will need to see your worksheet. Please post the your workbook for review.

Sincerely,
Leith Ross

thanks leith,

see the attached template.

We create the folders for each person on the basis of emp id as per Column B so path will unique and also the file name used for zip will be unique.

tks
MS

Hello mohanss82,

The delay was unavoidable. Whenever we get rain where I live, there seems to be no end to connection problems or power problems. I have added the 2 macros shown below to the attached workbook. There is button on the worksheet to run the macro.

Please Login or Register  to view this content.

Sincerely,
Leith Ross

Hi leith,

thanks for ur time.

I tried running the macro, and got a messg, "File not Found".

Required some more of ur time

Tks
MS

Hello mohanss82,

"File not found" can be caused by several things. The file path or file name may be mistyped, or the file folder doesn't exist or the file doesn't exist.

Sincerely,
Leith Ross

Hi Leith,

Thank you so much, I have been looking for this past one month and finally I am find it.

need a help here
I want the password to be combination of two columns and destination folder for the zipped files to a different one than in the path.