Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
quick zip/unzip form vba
Is there any zip/unzip standard procedure being part of Windows or
Office I can use from VBA? I have about 16 MB long string and would like to zip it before storing in Excel. Unfortunately it must work on any pc even freshly built so I can't assume existence of any non standard library on computer. Windows and Office and nothing more. Thanks. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
quick zip/unzip form vba
Hi Witek,
Am Tue, 22 Oct 2013 10:05:15 -0500 schrieb witek: Unfortunately it must work on any pc even freshly built so I can't assume existence of any non standard library on computer. Windows and Office and nothing more. have a look: http://msdn.microsoft.com/library/vs...ession.zipfile Regards Claus B. -- Win XP PRof SP2 / Vista Ultimate SP2 Office 2003 SP2 /2007 Ultimate SP2 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
quick zip/unzip form vba
Hi Witek,
Am Tue, 22 Oct 2013 10:05:15 -0500 schrieb witek: Unfortunately it must work on any pc even freshly built so I can't assume existence of any non standard library on computer. Windows and Office and nothing more. have a look: http://msdn.microsoft.com/library/vs...ession.zipfile Regards Claus B. Claus, this requires .NET Framework and so is not native VBA! Perhaps a place to start... http://www.jsware.net/jsware/vbcode.php5#zip -- Garry Free usenet access at http://www.eternal-september.org Classic VB Users Regroup! comp.lang.basic.visual.misc microsoft.public.vb.general.discussion --- This email is free from viruses and malware because avast! Antivirus protection is active. http://www.avast.com |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
quick zip/unzip form vba
Claus Busch wrote:
Hi Witek, Am Tue, 22 Oct 2013 10:05:15 -0500 schrieb witek: Unfortunately it must work on any pc even freshly built so I can't assume existence of any non standard library on computer. Windows and Office and nothing more. have a look: http://msdn.microsoft.com/library/vs...ession.zipfile Regards Claus B. thanks unfortunately, no .net allowed win32 only so I can write a wrapper Windows 7 is able to zip and unzip files but I do not know where this function is and if it is exposed as API. |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
quick zip/unzip form vba
See my reply to Claus for a link to one VB.zip utility. There's another
one here... http://www.Planet-Source-Code.com/vb...53174&lngWId=1 -- Garry Free usenet access at http://www.eternal-september.org Classic VB Users Regroup! comp.lang.basic.visual.misc microsoft.public.vb.general.discussion --- This email is free from viruses and malware because avast! Antivirus protection is active. http://www.avast.com |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
quick zip/unzip form vba
GS wrote:
See my reply to Claus for a link to one VB.zip utility. There's another one here... http://www.Planet-Source-Code.com/vb...53174&lngWId=1 Yes, I saw that. I did not have time to respond. Thanks a lot I am looking at that right now. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Unzip message box supression | Excel Programming | |||
Unzip fuction in excel | Excel Worksheet Functions | |||
unzip/zip xlsx files | Excel Discussion (Misc queries) | |||
unzip | Excel Programming | |||
Quick Form for updating a range? | Excel Programming |