zip excel sheet

Question

0.00/5 (No votes)

See more:

VB

Dim oZip As CGZipFiles

set oZip = new CGZipFiles

oZip.ZipFileName = "\MyZip.Zip"
oZip.AddFile "c:\mystuff\myfiles\*.*"
oZip.AddFile "c:\mystuff\mymedia\*.wav"

If oZip.MakeZipFile <> 0 then
   MsgBox oZip.GetLastMessage
End If

set oZip = nothing

when am writing this in my project .... the following error is coming...
CGZipFiles' is not defined.

Posted 3-May-10 18:50pm

sanug

Add a Solution

Comments

sanug 4-May-10 0:52am

please answer me....its very urgent.....thanks PG

1 solution

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

_Damian S_ · Accepted Answer · 2010-05-03T19:04:00

Solution 1

The error means that the type CGZipFiles has not been defined in your application.

This means you need to reference it (if it's a DLL or similar), or include a class module that provides the definition (and functionality) of CGZipFiles.

Posted 3-May-10 19:04pm

_Damian S_

Comments

sanug 4-May-10 1:07am

can you plz provide the class module?when i added the zip32 dll,again error is coming that it is not a valid component to be added....

sanug 4-May-10 1:08am

can u please provide some other code for zipping excel sheet using vb language..thnx in advance..

sanug 4-May-10 1:15am

please reply me...

_Damian S_ 4-May-10 1:22am

I don't have a copy of the library... I was simply giving you the general solution to a problem such as yours. Try google, and search for cgzipfiles download.

sanug 16-Aug-10 2:30am

thanks a lottttt:)

zip excel sheet

1 solution

Solution 1

Add your solution here

Preview 0

zip excel sheet

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us