[RESOLVED] zip file

[kamakshi]

i have huge large filexcel file converted into zip file. still it is larger. coudl not send email. is there any idea to do compress still

[Siddharth Rout]

Why is your excel file so heavy? What does it have? And yes, what is it's size?

[kamakshi]

file not found
ZipIt = Shell(ZipPath & "Winzip32 - a" & Dest & " " & Source, vbNormalFocus)

[Siddharth Rout]

file not found
ZipIt = Shell(ZipPath & "Winzip32 - a" & Dest & " " & Source, vbNormalFocus)

Not the answer that I expected....

Can you reread the question that I asked in post 2

[kamakshi]

kool
i have huge excel file. there are 10 sheets in it. that is 250mb when i zip it it comes wiht 30.25mb is it possibel still can i compress.

[LaVolpe]

Hmmm, 30mb after zipping? You may have to consider span zipping if WinZip allows that (look at your help files and command line help on WinZip.com). Spanning would allow you to break the file into multiple zips and WinZip would know to put them back together again during the unzip process.

Just some ideas, thinking out loud. Whichever method you end up using (except the first one below), you are most likely looking at sending multiple emails.

Other than that, you might be able to use another site to host the zip file and upload/download it from there.

Yet another option could be to create your own file splitter. Zip the 30mb file, then using an app you create, split it into say 10mb separate files and email them. This does mean that the receiver of your email would need the same app to put them back together again before unzipping the combined file.

And possibly one more option is to look into Window's Cabinent builder/extractor. Here's a link that briefly discusses it and you should be able to find examples by searching forums like this one and googling.

[westconn1]

rar may compress more than zip

[Siddharth Rout]

kool
i have huge excel file. there are 10 sheets in it. that is 250mb when i zip it it comes wiht 30.25mb is it possibel still can i compress.

I will come to the zipping part later...

What exactly do you have in that excel file. I want to understand why is the file so heavy?

Also have a look at this link...

http://www.vbforums.com/showthread.php?t=450967

[kamakshi]

the file has 12 months each month has huge amount of data. 12 months sheets have 256mb if i remove the blank spacess it does not much reduced. can yuo help me in anyother way

[illskills]

disk spanning is your solution ^^^ what LaVolpe said

split the file into small chunks and send them individually

[kamakshi]

yes i got solution when zip change the split size and zip it.

[Siddharth Rout]

the file has 12 months each month has huge amount of data. 12 months sheets have 256mb if i remove the blank spacess it does not much reduced. can yuo help me in anyother way

does your excel have lot of pictures/images?

[kamakshi]

no only formuale andformated each cell. it is handled by so many users

[Siddharth Rout]

no only formuale andformated each cell. it is handled by so many users

If it is just that then trust me there is something wrong with your workbook

Ok do this....

1) MAKE A BACKUP OF YOUR WORKBOOK.

2) Go to the last row of every worksheet and then select all rows after that till the end of the worksheet. Once selected, delete them.

3) Repeat the same exercise with columns. delete all columns after your last column till the last column of each worksheet.

4) Now check the size....

[kamakshi]

yes you are right. thanks kool