open Microsoft Photo Editor using createobject 1

[gungfukid]

Can someone please tell me how I can open an instance of Microsoft Photo Editor using createobject. The Access help files only give an example of how to open an instance of Excel.

Thanks in advance

 

[BillPower]

Hi gungfukid,

This will open Photo Editor on its own:
Call Shell("C:\Program Files\Common Files\Microsoft Shared\PhotoEd\PHOTOED.EXE", vbNormalFocus)

This will open Photo Editor with a specified image file:
Call Shell("""C:\Program Files\Common Files\Microsoft Shared\PhotoEd\PHOTOED.EXE"" ""C:\my documents\my pictures\Cliff in Clouds.jpg""", vbNormalFocus)

Edit the above if necessary if PHOTOED.EXE is in a different location on your PC.

Bill

 

[gungfukid]

Cheers billpower,

just what I needed and worked like a dream.