Email:      Pass:    Pass?
Close Window   
TE
Subscribe for Email Updates!
Excel tips, help, and more!
E-mail:


Advertisements


Free Excel Forum

Optimising Picture Size With Compression

Forum Register
Search Excel Forum Posts, Tutorials, Macros, Tips, and More

Through VB how can I optimise the compression of pictures in my workbook?
Assume I want to open the document and then optimise all the pictures in the
document. Thanks in advance






Similar Excel Video Tutorials

Helpful Excel Macros

Open a Word Document from Excel
- This Microsoft Excel macro will open a Microsoft Word document from excel. With this macro, you can open any word docume
Open Microsoft Word from Excel
- This free macro will open the Microsoft Word program on your computer. You do need to have this program first. This wi
Disables the "Save As" Feature in Excel
- This macro will disable the Save As feature in excel. This means that a user will not be able to resave the workbook un
Send Emails through Outlook using Email Addresses from Excel and text from Word
- This macro allows you to send an email to a list of recipients through excel. The email will be sent through Outlook an
Complete Guide to Printing in Excel Macros - PrintOut Method in Excel
- This free Excel macro illustrates all of the possible parameters and arguments that you can include in the PrintOut Meth

Similar Topics







Does anyone know why some pictures inserted into Excel 2003 will "Compress" (deleting the cropped sections and compressing the picture) and some don't seem to ?

Some pictures I inserted revert back to their full "uncropped" views, after I go through the compression process.

Thanx in advance.

MJC


Does anyone know why some pictures inserted into Excel 2003 will "Compress" (deleting the cropped sections and compressing the picture) and some don't seem to ?

Some pictures I inserted revert back to their full "uncropped" views, after I go through the compression process.

Thanx in advance.

MJC


Hi,
Here's the problem: I have tried creating picture links on a new worksheet in the book by Copy-->Paste as Picture Link, and also by using the camera tool. After only a few pictures, I check the Print Preview and find that only some pictures show in the print preview. Other times, no pictures show in the print preview ( I end up looking at a single blank page for print preview, although the document contains a few pages of pictures.
I am using Excel 2007. I created the XL07 workbook by copying some sheets from an Excel 2003 workbook, but I don't think that's the root of the problem, as they were only data worksheets. All the pictures have the property set to print, and I also have show all selected under Options.
Furthermore, if I print the document to PDF, the PDF is blank, but a ghost image of the pictures can be seen with Ctrl+A (Select All)
Please help! I don't understand why sometimes some pictures show, while other times, other pictures show instead. The picture link in 2003 has been reliable for me, but I need to use Excel 2007 because of the larger worksheet size.
Sincerely,
Amy


Hi,

Here's the problem: I have tried creating picture links on a new worksheet in the book by Copy-->Paste as Picture Link, and also by using the camera tool. After only a few pictures, I check the Print Preview and find that only some pictures show in the print preview. Other times, no pictures show in the print preview ( I end up looking at a single blank page for print preview, although the document contains a few pages of pictures.

I am using Excel 2007. I created the XL07 workbook by copying some sheets from an Excel 2003 workbook, but I don't think that's the root of the problem, as they were only data worksheets. All the pictures have the property set to print, and I also have show all selected under Options.

Furthermore, if I print the document to PDF, the PDF is blank, but a ghost image of the pictures can be seen with Ctrl+A (Select All)

Please help! I don't understand why sometimes some pictures show, while other times, other pictures show instead. The picture link in 2003 has been reliable for me, but I need to use Excel 2007 because of the larger worksheet size.

Sincerely,

Amy


I have searched high and low and I havent been able to get any VBA code which will compress pictures.

A lot of the posts over t'internet say that it will come in a future version. These post were years old... so is it here yet?

Does anyone know the code to compress pictures in Excel 2007

Recording a macro doesnt pickup the compression parts

Any help would be appreciated


Regards


I'm adding pictures to my Excel 2010 document via Comments. Every time I open the document my picture sizes are changed from how I originally formatted and saved them.

Is there a way to make the sizes static, so that each time I (and the end user) open the document, my comment pictures will stay the size that I originally specified them?
Thanks much for any help you can give me.


Hi,

When trying to compress a very large Excel file (>30MB) either with Winzip
or WinRar, the compression does not result in a significant reduction (max.
-3% only in the best compression mode).

From my experience it seems to me that there is something like a
'hidden/magic' limit around ~25 MB and below this a compression is not a
problem, but above it is. Even if the large file is reduced back to a very
small one, the compression still does not result anymore in a significant
reduction (e.g. when deleting data in the >30MB file to bring it back to 5MB,
the following compression result is still max. -3%).

The size of the >30 MB is mainly driven by: ~2500 data sets as rows with 50
basis data information columns plus further 150 complex calculation columns
including lookup references to around ~30 parameter tables on another sheet.
Additionally, around 30 referenced charts are part of the file plus 1 pivot
overview table for the result.

The most commonly heard resolution approach is to do it at least in Access
and not in Excel due the data amount and required
calculation/parameterization effort. BUT there is a business reason behind
why it is done this way. Hence, does anybody has a good idea how to get the
file compressed to a size ~ 5MB (that's what I reach if the basis file is
<25MB)?

I have also heard that this issue is maybe related to an 'Excel internal
compression algorithm'. Does anybody know something about this?

I really appreciate your feedback/support and would like to thank you for
your help in advance,
Thorsten



Hi,

I have a document with many pictures. I don't save the document as a ms word doc file. I save it as a webpage , It works fine but everytime I edit this file, some pictures will be replaced with the pictures i recently added. Its making me feel uncomfortable.

How can I fix this?

Thanks


Okay, I've been working on Excel for years. I really know how to do what I'm trying to do, but I think I'm missing something.

In excel 2003, to compress all the images within a workbook, you just double clicked the image, chose compress, and voila! you had it taken care of.

In 2007, they changed it up a bit. I have selected an image, gone to the Picture Tools-->Format-->Adjust-->Compress Pictures tool. Since I am trying to compress ALL images within the workbook, I am leaving the box "Apply to selected pictures only" unchecked. I choose the smallest option in the Options menu and then click "ok". Guess what...No change.

If I select EVERY image and then I DO check the "Apply to selected pictures only" box, then the compression actually takes place. Am I missing something? I am having to find an old computer every time I need to size a file down and its getting kind of ridiculous.

Damn Microsoft. Why'd they have to change a good thing and make it no better? Someone please make me eat my words.


In Excel 2010, when you export to PDF manually, the export options include this checkbox:

Code:

ISO 19005-1 compliant (PDF/A)


and under Tools you can change the Picture Compression settings.

Is there a way to access these properties from VBA?

Many thanks in advance,

Nils


When I insert pictures into an Excel spreadsheet, the pictures are 14" wide.
How do I set the size of all pictures to be inserted to be 2" so I can see
the entire picture on my screen. From there I can move, crop, resize etc..



I am embedding a picture by filling a comment box. I have a number to do in each of my 3 tables. With each picture being 2.5 MB I had to shrink the size of the pictures first. The last 2 tables worked great, the whole file size is under 1MB. But the first table I did the file saved much larger, 37 MB. I looked at the size of each of the 20 pictures I used and they all ranged between 30 - 45 kB. so I started to troubleshoot and I removed one picture at a time and resaved. The file size did not decrease until all "comments" (pictures) were deleted. Then the file was down to 37 kb. From there I would add one picture and my file would baloon to 37 MB again. I would delete the "comment" and add a different picture and it would baloon once again.
How does a file increase from 37 kB to 37 MB just by embedding a 40 kB picture?


Hi all,

I am using an excel X-Y scatter chart to present some management information, plotting points on a simple matrix. Each point has been set up as a separate series, as each one represents a different item, and I want to use the items reference as the data label.

In order to enhance the appearance, and also as a workaround for duplicate values, I had formatted the data labels to be pictures using:

Format data labels, Area fill effects, pictures - and just picked up a picture from clipart. This all worked fine, and I saved the document.

However, when I close and re-open the workbook, the pictures have become corrupt and are no longer present. I have to repeat the procedure for allocating the picture in order to get it back again.

Any ideas for workaround, or if this is a known problem?

Thanks,

Steve


Hi
I need some help in finding or developing a compressing technique, which can compress a 7 number string i.e., 11,10,1,2,10,7,5 down to 6 or 5 lossless, that would be amazing.

I already researched many compression technique; Huffman, Run-Length and LZ78 which all do well on large data sets and I only have a few numbers. If it helps by converting the numbers to binary for better compression then I what to known. I know that a solution could be impossible as we would know about it already but may be someone knows a trick to get rid of one digit, then that helps...


Hi

I can't figure this one out. I have a jpeg image in the My Pictures folder. I have a mail merge source file (excel file) and a word document I'm trying to insert the picture into using mail merge. The example on the msdn website doesn't work as this is what I'm doing below.
I've tried to refresh the field by hitting F9 but still nothing. It just comes up with a blank picture frame in my word document.

In the excel file (source file) in the "Pictures" column I put the below.

Code:

"C:\\Documents and Settings\\Username\\My Documents\\My Pictures\\testpic.jpg"





In the word document field where I want to insert the picture I put the below.

Code:

{INCLUDEPICTURE { MERGEFIELD "Pictures" } \*MERGEFORMAT\D}


I've tried with and without the \D at the end but it makes no difference.
I have also tried with and without quotation marks around "Pictures". Still no difference.

Any clues as to how I can get this to work?

Thanks so much.


Whoa! You might be asking yourselves. What does this guy really want?

I've honestly searched the Internet for I don't know how many hours, so you guys are my last chance

I would like to add pictures to my worksheet without having to resize them manually because of lengthy time factor and what more, the lines on which the pictures are placed don't adjust themselves to the size of the pictures.

My problem is that I need to make a product inventory in which there would be a picture next to the description of the product. The pictures would be 6,4 x 4,8 cm or 4,8 x 6,4 cm.

I would like to know if there's a way to format the cell so that when I drag (from the explorer) a picture to where it should go, it doesn't "float" over the line but goes into the cell and adjusts itself to the size of the cell!

Help me out guys, I really need this to work!

Thanks for your help and advice.


Hello,
My name is Eddie and this is my very first board posting, so please have mercy on me.
I am not computer proficient or savvy but normally with time and dedication I find my way around but I have hit a roadblock with the 'insert pictures feature'
I created an inventory worksheet where I store a lot of information about my stock and sales.
The problem I have is that the pictures do not stay attached to the row.
Sometimes I need to do ceratin sorts or remove certain rows in a document but the pictures do not 'move' with the row, the just stay there overlaping (overimpossing) with the previous row.
I imagine there is a command that I need to execute once I have inserted the picture from a file so that picture will become an integral part of the row and will stay with the row.
Can somebody advise on what I have to do?
Thank you in adavance!
Eddie


I have searched several blogs and have not found a solution and hoping someone can help. Just upgraded from Excel 2002 to 2010 and when saving a file that was roughly 5.5 MB it exploded to 26 MB even when trying to recreate as a 2010 version (same size as when saving in 2002 format).

The file has several macros and copy roughly 50 charts as pictures into individual sheets since e-mail the summary and do not want to copy all of the other spread sheets. Know that the file expansion size is due to the pictures. So any suggestions when copying charts to possibly other format, compression techniques or other to get file size below 10 MB so it can be e-mailed?

Thanks for any assistance as this was a suprise.


Good Evening everyone,

I am currently looking to figure out the best way to do some image replacements in Excel.

Basically the pictures may change every so often, and we have a root folder where all the pictures are stored.

I would like Excel to Index and Match the pictures based on the item number that we assigned each picture. Is this possible with conditional formatting or do I have to make a macro?

Example:
Picture placeholder that is 300x300 is in the excel file.
Picture Folder that has 300x300 pictures is in the same directory.
Some pictures are updated and I move them to the Picture Folder.
I now F9 or open excel, all the pictures are loaded from that folder, and are in the same position as the previous placeholder.

Is this possible, and what about be your suggestions on going about this. I am thinking something like INDEX and MATCH, but how can it match the picture. I am thinking naming all the pictures the same code, as the code on the spreadsheet. And from that, it replaces the picture.

Thanks!


I have a worksheet which is filled with a bunch of pictures, and
depending on the layout I have there will need to be up to 500-2,000
pictures.... maybe more.

There are only six 'different' pictures however, most are copies of a
reference picture.

I want to be able to hide all the pictures or show them depending on
the value of a checkbox in a userform. Here is the code I have
(chkQCAoverlay is a check box):

Private Sub chkQCAoverlay_Change()

On Error Resume Next
Worksheets(2).Pictures.Visible = chkQCAoverlay.Value
On Error GoTo 0

End Sub

The 'on error' is there in case there are no pictures on the worksheet.


The code works if I have a few pictures (around 30) but if I have many
more, it stops hiding the pictures. Anyone know what's going on?




I have a spreadsheet which I PDF using cutepdf, There are images in the spreadsheet that look very sharp in excel but when viewed as a pdf the graphic is low resolution?
When right clicking the graphic image and format picture there is a button for compression which seems to be checked all the time (Excel 2003).
How can This be overcome?




At work lots and lots of pictures are taken of work and machines in the field. People in general are not disciplined (myself being below average ) when it comes to sorting and storing pictures on disk and lots and lots of pictures end up being stored two or more times in different folders.

Is there a program that will move (or copy) all uniqe pictures from multiple folders to a new folder?
The purpose of this would of course be to get rid of all duplicate pictures. Not only do they take up space but searching for a certain picture also becomes much more cumbersome.

I assume such a program is available but if not that may be my next VBA project.

With the help of you guys (Thanks as always) I have built my sheet to import numerous pictures and resize them to the cell size. Obviously if I have imported a couple of hundred pictures the size of the workbook is very big. I can get over this by deleting all pictures on close and re-importing them on opening. However I wondered is there a way for excel to change the filesize of numerous pictures.
I can of course change their filesize in a picture editing program before importing but wondered if I can do this in excel as I bring them in?

The more I am getting into this the more I'm thinking there's almost nothing you can't do in excel




Hi,
can you take a look at the attachment?

My question is.
What is the optimal order to produce these products, so that ENERGY COST TOTAL is minimal?
I assume we have 120 possibilities in this case.
A,B,C,D,E
A,B,C,E,D
A,B,D,C,E
A,B,D,E,C
etc,
We don't want to split products hourly. The same products should be produced in a row.

Can anybody help me to optimise this?
Macro, visual basic code?
Any help, I don't want to optimise manually everyday ;-)

Thanks, Lauri.

I'm trying to find a way of creating a code which optimises the display in the Excel 2007 workbook. What I mean by this is if the user zooms into a table for example in a worksheet, if they decide to click on the 'Optimise Display' button, it presents them with the original zoomed out view of the table.

So far, I have a module consisting of:

Code:

Sub size1()
'
' size Macro
' Macro to auto-optimise display

    Application.ScreenUpdating = False
    Application.Goto reference:="size"
    ActiveWindow.Zoom = True
    Application.Goto reference:="R1C1"
    Application.ScreenUpdating = True
End Sub


I was however given this code and I'm trying to find out how it's meant to work because it isn't at the moment.

I need to know how to create a macro which sets the spreadsheet to a certain zoom %.