PDA

View Full Version : I need an on-the-fly vba compression routine/addin to read/write text files



Teacher5th
03-02-2008, 11:19 PM
I want to send and receive data in a worksheet in text mode but zipped across my network. The routine would take a range of cells, convert to text, compress and then send to another computer as well as read a compressed file back into a worksheet. I have all but the compressing done. Thanks

Bob Phillips
03-03-2008, 01:59 AM
See http://www.rondebruin.nl/zip.htm or http://www.rondebruin.nl/windowsxpzip.htm or

Teacher5th
03-03-2008, 08:48 AM
Thank you for helping my classroom. Those addresses will work fine. I was wondering if there are any addins that unzip on-the-fly. Although these will work, when you unzip, you have to unzip to a file and then read the file in. Do you know of any addins that stay in memory that will zip and unzip - or any compression format - without shelling out or writing addtional file before placing the data into the cells?

Bob Phillips
03-03-2008, 08:58 AM
Sorry, I only kn ow of Ron's efforts in this field. I must admit to being surprised when he developed them, couldn't see a market, but there obviously si one <bg>