Code to compress files in XP

L

Lawlera

Hi

I would like some code to compress (through Windows XP) an unopen excel file and then copy the compressed file to the a:\ drive

Thanks in advance.
 
F

Frank Kabel

Hi
do you want to do this within Excel?. I would suggest susing a
different tool (OS scheduler, etc.). But if you want to use Excel you
may goto the WINZIP homepage. They have a command line extension which
you may call with the Shell Command from Excel
 
L

Lawlera

Sorry Frank, should have said - yes I do want to do this from within excel

Thanks for the advice.
 
Top