Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Sydney, Australia, New South Wales, Australia
    Posts
    251
    Thanks
    0
    Thanked 4 Times in 4 Posts

    Using VBA to automate MS Photo Editor

    Hi
    Win XP, Office 2002.
    Is it possible to automate MS Photo Editor via VBA? I want to load a JPG, resize and save a bunch of files.
    (Installing other software on the machine is difficult.)
    Thanks for any suggestions - a URL or two would be much appreciated.
    Peter

  2. #2
    2 Star Lounger
    Join Date
    Mar 2010
    Location
    Tampa, FL, USA
    Posts
    114
    Thanks
    11
    Thanked 9 Times in 8 Posts
    Unless you need VBA to control the operation, you may want to look at a portable application that doesn't require installation.

    One example is Faststone Photo Resizer, located here.
    PJ in FL

  3. #3
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts
    I have used Irfanview to batch resize photos. I see from the website that it can work as a portable application - from a USB stick.

    You run it from VBA with the Shell command, using various command line switches that are dcoumented in the Irfanview help files.
    Regards
    John



Posting Permissions

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