Code to compress files in XP

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
Sorry Frank, should have said - yes I do want to do this from within excel

Thanks for the advice.
 
Back
Top