Results 1 to 3 of 3
  1. #1
    Lounger
    Join Date
    Oct 2001
    Location
    Upper NY State, USA
    Posts
    36
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Office 2003 Microsoft Picture Manager (SP2)

    Is there any way to automate the resizing and exporting of a .jpg image from another office product via vba by adding Microsoft Picture Manager as a programming reference?

    Thank you for any assistance you may be able to offer.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Office 2003 Microsoft Picture Manager (SP2)

    I don't think Picture Manager has an exposed programming interface. Perhaps you can use Microsoft Office Document Imaging - you can set a reference to that. See
    Microsoft Office 2003 Edition Document Imaging VBA Language Reference and
    Using the Microsoft Office Document Imaging 2003 Object Model

  3. #3
    Super Moderator jscher2000's Avatar
    Join Date
    Feb 2001
    Location
    Silicon Valley, USA
    Posts
    23,112
    Thanks
    5
    Thanked 93 Times in 89 Posts

    Re: Office 2003 Microsoft Picture Manager (SP2)

    If you are able to download and install a large open source program, ImageMagick has a COM object interface that lets you do amazing things. The COM object actually is a wrapper around the program's command-line interface; very interesting but initially difficult to figure out as the documentation is sparse. <img src=/S/sad.gif border=0 alt=sad width=15 height=15>

    I have used the ImageMagick control in a PowerPoint VBA project as follows: (1) export slide as PNG, native PowerPoint command; (2) convert PNG to GIF, erasing a pre-selected background color, using the ImageMagick control; repeat. As always when working with unfamiliar COM interfaces, save often to avoid code loss when PowerPoint suddenly closes for no reason!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •