Excel

Photo Handler

Ease of Use

Easy

Version tested with

2003 

Submitted by:

mdmackillop

Description:

Allows inspection of pictures within Excel, renaming, deleting and rotating to correct orientation. 

Discussion:

This KB Item uses a third party application, IrfanView, to manipulate and save the pictures (free for personal use). Thanks to XLGibbs and Ken Puls for much of the code. 

Code:

instructions for use

			

As this Is a Utility rather than the usual item, all code Is contained within the example.

How to use:

  1. Extract the attached file to a suitable location.
  2. Make a copy of a picture folder for tesing
 

Test the code:

  1. Open the file and browse to the folder containing your pictures.
  2. View the files by selecting the file name
  3. Try renaming/deleting files
  4. If Irfanview is installed, test rotation of files.
 

Sample File:

ViewRenameDeleteFiles.zip 30.76KB 

Approved by mdmackillop


This entry has been viewed 443 times.

Please read our Legal Information and Privacy Policy
Copyright @2004 - 2020 VBA Express