VBA to 7-zip file

[DanzaNZ]

Hi all

Does anyone know a code to 7-zip an excel file?

I am really lost on this one.

Cheers
Dan

[HaHoBe]

Hi, Dan,

did you have a look at Zip Activeworkbook, Folder, File or Files with 7-Zip (VBA) and Unzip a zip file with 7-Zip (VBA)?

Ciao,
Holger

[DanzaNZ]

Thanks HaHoBe

I did see this before, but it looks really confusing.
I was wondering if anyone could direct me to one code to use.

[DanzaNZ]

Ah, I have it working, however I need this following code to have a password in it, to protect the Zip File

Any ideas?

Please Login or Register  to view this content.

[HaHoBe]

Hi, Dan,

have a look at -p (set Password) switch and alter the command line code line accordingly.

Ciao,
Holger

[DanzaNZ]

Thanks HaHoBe

I am still a bit lost as to where I put this line:

Please Login or Register  to view this content.

[HaHoBe]

Hi, Dan,

the code line for compressing in your code is

Please Login or Register  to view this content.

You would need to replace that line with

Please Login or Register  to view this content.

where secret is the password for the file.

Ciao,
Holger

[DanzaNZ]

Thanks for your input; however this does not appear to be working.
It says the file has been zipped, but no zip file is at the location it specifies

[HaHoBe]

Hi, Dan,

as I´m away from my hime PC I can only test the code on Friday evening when I returned. Until then I´d suggest to create a zip archive with the first code supplied and convert that to a password protected archive with the second example.

I´ll be back his weekend when I have tested what´s wrong with the code supplied.

Ciao,
Holger

[DanzaNZ]

Hi HaHoBe

Here is a better code, which works but it only zips files individually.
I would like it to zip all files in the DEST folder

Your help would be appreciated.

Cheers Dan

Please Login or Register  to view this content.

[DanzaNZ]

For those interested in 7-zipping a folder: this is what I have used with my code above

Please Login or Register  to view this content.