Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi everbody,
I tried to compress pictures with a makro. If I do manually, format graphic -- compress -- web/monitor 96 dpi, it works, but when I record this with the makro recorder and play it, it doesen't work. Here is the code which I record: Selection.ShapeRange.PictureFormat.Brightness = 0.5 Selection.ShapeRange.PictureFormat.Contrast = 0.5 Selection.ShapeRange.PictureFormat.ColorType = msoPictureAutomatic Selection.ShapeRange.PictureFormat.CropLeft = 0# Selection.ShapeRange.PictureFormat.CropRight = 0# Selection.ShapeRange.PictureFormat.CropTop = 0# Selection.ShapeRange.PictureFormat.CropBottom = 0# So can anybody help me, how I can compress an image with VBA??? Thanks for your answers?? Micha |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do you export pictures from my pictures file into a word docu | New Users to Excel | |||
Compress Pictures function doesn't work? | Excel Discussion (Misc queries) | |||
Some pictures did not compress | Excel Discussion (Misc queries) | |||
Pictures.Visible question (after adding many pictures, they stop disappearing) | Excel Programming | |||
Excel's Compress Pictures or deleting pictures doesn't seem work | Excel Discussion (Misc queries) |