Results 1 to 12 of 12

EXCEL, VBA, Image: Image loses transparency after saving woorkbook

Threaded View

  1. #1
    Registered User
    Join Date
    04-12-2011
    Location
    San Jose, California
    MS-Off Ver
    Excel 2003
    Posts
    17

    EXCEL, VBA, Image: Image loses transparency after saving woorkbook

    APPLICATION AND SYSTEM: Excel 2007, WINDOWS 10

    PROBLEM: Imported images with transparent backgrounds appear as expected until the workbook is saved, closed and then re-opened. Upon re-opening, the image appears but without the original transparent background.

    QUESTION: How is the transparent background of an imported gif preserved when the workbook is saved and closed.

    BACKGROUND: I have a workbook which uses the LoadPicture(Application.GetOpenFilename) function to allow the User to populate a Image field with a picture. In our case we will be limiting the selected file(s) as gif format and recommending only those with transparent backgrounds. We then use Worksheets("{SHEET NAME}").Activate: ActiveSheet.OLEObjects("{TARGET IMAGE CONTROL}").Object.Picture = {CURRENT PAGE IMG}.Picture to 'copy' the selected image to image controls on several other sheets in the work book.

    Selecting images and populating image controls now work well: The selected images with transparent backgrounds appear as expected - transparent. However, when re-opening the saved workbook selected images appear without their original transparent backgrounds.

    Any help resolving this would be very much appreciated.

    Regards,
    Last edited by lhasha; 06-17-2016 at 04:03 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Insert Image with transparency
    By Slurry Pumper in forum Excel General
    Replies: 5
    Last Post: 01-19-2016, 03:50 PM
  2. VBA Script for saving an image from Excel to PNG file thru MS Paint
    By alexgempesaw in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-21-2015, 08:09 PM
  3. [SOLVED] How to apply Image borders to an image that my excel vba userform pastes in a word doc?
    By CaptainCool in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-11-2014, 05:40 PM
  4. Excel 2010 "vlookup pictures vba" links image instead of saving it as an image
    By neverdom in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-28-2013, 04:17 AM
  5. Image with transparency on other picture in Userform
    By vanMourik in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-26-2013, 11:57 AM
  6. VBA: Put text from excel to jpeg image by matching image name.
    By sroysroy in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-12-2013, 01:47 AM
  7. excel 2010 VBA InsertPicInRange only makes shortcut to image instead of copy of image
    By ArjanSpit in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-10-2012, 02:57 PM

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1