Hi,
I have some VBA code which uses winzip to create a temp copy of the current excel workbook, then save it to a zip file.
My problem is that it only acheives around a 34% compression ratio (from 482k to 330k approx). Does anyone know how to get the maximum possible compression ratio out of winzip using vba code? The speed of opening these files is not important.
I'm using windows 2000, excel 2000 and winzip 7.
Thanks,
Knifey
I have some VBA code which uses winzip to create a temp copy of the current excel workbook, then save it to a zip file.
My problem is that it only acheives around a 34% compression ratio (from 482k to 330k approx). Does anyone know how to get the maximum possible compression ratio out of winzip using vba code? The speed of opening these files is not important.
I'm using windows 2000, excel 2000 and winzip 7.
Thanks,
Knifey