Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to Compress Pictures using VBA
I'd like to add the compression of pictures to a Workbook application using
VBA. I believe I've found that this functionality is not directly exposed to VBA. I have found that I can bring up a Compress Picture dialog in the Click event of a command button by invoking: CommandBars.FindControl(ID:=6382).Execute However, this does NOT compress my pictures. If I manually select the picture(s) and select the Compress Picture button and compress, the pictures do compress. The worksheet containing the pictures is usally protected. I have added code around the Compress Picture code to unprotect the worksheet and protect it after compression. No affect. I'm developing in Excel 2007 but saving the document in the Excel 98-2003 format. Has anyone successfully compressed pictures using VBA or have any tips/suggestions? Thanks! -- Jack << |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to Compress Pictures using VBA
Jack,
AFAIK, you cannot from within Excel. There may be an application that can be used as a reference that allows you to do so, but it is not native to Excel. HTH, Bernie MS Excel MVP "Jack" wrote in message ... I'd like to add the compression of pictures to a Workbook application using VBA. I believe I've found that this functionality is not directly exposed to VBA. I have found that I can bring up a Compress Picture dialog in the Click event of a command button by invoking: CommandBars.FindControl(ID:=6382).Execute However, this does NOT compress my pictures. If I manually select the picture(s) and select the Compress Picture button and compress, the pictures do compress. The worksheet containing the pictures is usally protected. I have added code around the Compress Picture code to unprotect the worksheet and protect it after compression. No affect. I'm developing in Excel 2007 but saving the document in the Excel 98-2003 format. Has anyone successfully compressed pictures using VBA or have any tips/suggestions? Thanks! -- Jack << |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to Compress Pictures using VBA
Thanks!
-- Jack Waller << "Bernie Deitrick" wrote: Jack, AFAIK, you cannot from within Excel. There may be an application that can be used as a reference that allows you to do so, but it is not native to Excel. HTH, Bernie MS Excel MVP "Jack" wrote in message ... I'd like to add the compression of pictures to a Workbook application using VBA. I believe I've found that this functionality is not directly exposed to VBA. I have found that I can bring up a Compress Picture dialog in the Click event of a command button by invoking: CommandBars.FindControl(ID:=6382).Execute However, this does NOT compress my pictures. If I manually select the picture(s) and select the Compress Picture button and compress, the pictures do compress. The worksheet containing the pictures is usally protected. I have added code around the Compress Picture code to unprotect the worksheet and protect it after compression. No affect. I'm developing in Excel 2007 but saving the document in the Excel 98-2003 format. Has anyone successfully compressed pictures using VBA or have any tips/suggestions? Thanks! -- Jack << |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Compress Pictures function doesn't work? | Excel Discussion (Misc queries) | |||
Some pictures did not compress | Excel Discussion (Misc queries) | |||
Compress Pictures with VBA | Excel Programming | |||
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) |