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

--
Regards
Frank Kabel
Frankfurt, Germany

Lawlera wrote:
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.

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

Thanks for the advice.

Hi
you may have a look at the following thread for some example code
http://tinyurl.com/3yfwf

--
Regards
Frank Kabel
Frankfurt, Germany

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

Thanks for the advice.