Excel:Mac Support for JPG Files in User Form Image Controls

[stardog2000]

Version: 2004
Operating System: Mac OS X 10.5 (Leopard)
Processor: Power PC

What I am trying to do. . .

Programatically (VBA) change the image (picture) in an Image Control when a User Form containing that control is displayed. I essentially have a database of items (each with a picture) to display in a User Form.

Documentation for Image Controls indicate they should support JPG/JPEG files.

When I attempt to load a JPG image I get an "Invalid Picture" error.
If I use the same VBA code except that the path to the file has been changed to point to the image in .BMP format it works fine.

This statement pointing to a .BMP file works fine . . . .
DEForm Image6.Picture = LoadPicture("SAGAN:Users:stardog2000ictures:Home Inv Master Picturesopey Clock - Pewter.bmp")

This statement pointing to a .jpg file produces the Invalid Picture error.
DEForm Image6.Picture = LoadPicture("SAGAN:Users:stardog2000ictures:Home Inv Master Picturesopey Clock - Pewter.jpg")

I suppose I could convert all pictures from jpg to bmp but jpg is more commonly used and I don't really feel it should be necessary.

Could this functionality be part of an excel add-on or a preference I am missing

Thanks Dave

 

[Bob Greenblatt]

Version: 2004
Operating System: Mac OS X 10.5 (Leopard)
Processor: Power PC

What I am trying to do. . .

Programatically (VBA) change the image (picture) in an Image Control when a
User Form containing that control is displayed. I essentially have a database
of items (each with a picture) to display in a User Form.

Documentation for Image Controls indicate they should support JPG/JPEG files.

When I attempt to load a JPG image I get an "Invalid Picture" error.
If I use the same VBA code except that the path to the file has been changed
to point to the image in .BMP format it works fine.

This statement pointing to a .BMP file works fine . . . .
DEForm Image6.Picture = LoadPicture("SAGAN:Users:stardog2000ictures:Home Inv
Master Picturesopey Clock - Pewter.bmp")

This statement pointing to a .jpg file produces the Invalid Picture error.
DEForm Image6.Picture = LoadPicture("SAGAN:Users:stardog2000ictures:Home Inv
Master Picturesopey Clock - Pewter.jpg")

I suppose I could convert all pictures from jpg to bmp but jpg is more
commonly used and I don't really feel it should be necessary.

Could this functionality be part of an excel add-on or a preference I am
missing

Thanks Dave

Seems like jpeg files do not work properly on Macs. Microsoft is aware of
the issue, but there is no fix. See Knowledgebase article 175918.