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
Printable View
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
Why is your excel file so heavy? What does it have? And yes, what is it's size?
file not found
ZipIt = Shell(ZipPath & "Winzip32 - a" & Dest & " " & Source, vbNormalFocus)
Not the answer that I expected.... :)Quote:
Originally Posted by kamakshi
Can you reread the question that I asked in post 2
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.
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.
rar may compress more than zip
I will come to the zipping part later...Quote:
Originally Posted by kamakshi
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
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
disk spanning is your solution ^^^ what LaVolpe said
split the file into small chunks and send them individually
yes i got solution when zip change the split size and zip it.
does your excel have lot of pictures/images?Quote:
Originally Posted by kamakshi
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 :eek2:Quote:
Originally Posted by kamakshi
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....
yes you are right. thanks kool