I am trying to record a macro to format (compress a picture) in a 4 sheet work book but when I go through the motions, no macro. Anyone able tell me why ?
I can record a macro that resizes an inserted picture in the same sheet so I must be missing something.
I'm a newbie to macros and can't find any reference in help files etc.
When you say 'compress' a picture. what do you mean? Are you using a program other than excel? e.g. winzip or somesuch?
Emm100
Thanks for repying Emm100.
No, this is in excel 2003 not winzip or similar.
If you insert a picture (.jpeg in this case), right click on the image and select "format" you have the option to compress it.
It is this action that won't record as a macro and I wanted to know if there is a way to get around this and why it won't record.
Last edited by Davi0; 05-17-2005 at 11:19 AM.
Davi0
I managed to get this to record ok. I think what's confusing you is that the 'compression' is actually a series of actions which excel performs, you won't find a line of code saying Activesheet.shapes("picture 1"). compress or anything like that. For example in the picture i tried to compress it wound up as.....
Basically all excel does is amends a bunch of settings, most signifcantly the colourtype so that the picture requires less storage space. See if you have some similar lines to those above in your macro code, I think you have and that these are the 'compression'
Please Login or Register to view this content.
Emm100
Emm100
Yes, my macro looks like this also. problem is it doesn't appear to work. If you take an image and run the macro on it, then do this process manually you will find that the image size doesn't reduce the same. Or at least in my instance it doesn't.
Davi0
This is probably because Excel finds the best possible combination of properties for THAT picture. if you are trying to apply them to another picture the it won't 'fit'
I have been looking around for another way to automate this and i can't seem to find anything. What i did find was a post on another board recently which suggests that MS actually haven't actually got a property related to this feature set up (http://www.msusenet.com/archive/index.php/t-2768263.html )
I'm afraid i don't know of any other ways to reduce the size of a graphic except for changing the colourype property, which we've already tried. Perhaps someone else can help?
Apologies I can't get you any futher with this one.
Ok, this explains why both macros recorded look almost the same.
Last hope has nearly evaporated, looks like a manual process !
Thanks heaps for your input Emm100.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks