Results 1 to 3 of 3
  1. #1
    trevor40's Avatar
    trevor40 is offline Advanced db Manager
    Windows XP Access 2003
    Join Date
    Feb 2014
    Location
    Australia
    Posts
    402

    copy OLEUnbound picture on form to excel worksheet

    Hi again all,



    for my next trick i have to copy a company logo that is on my main form, 'oleunbound_logo'
    and then paste it into a worksheet, i can handle where on the sheet and the size but can't get it from the access form. as this is being automated from access it would be hard to insert the picture from a file using just excel, but if i have to i will go down that road.

    i was hoping i could just do a me.oleunbound_logo.copy but that didn't work.

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,926
    AFAIK, will have to do an image insert action on the Excel sheet with external image file.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    trevor40's Avatar
    trevor40 is offline Advanced db Manager
    Windows XP Access 2003
    Join Date
    Feb 2014
    Location
    Australia
    Posts
    402
    i was guessing that, o well thats what i'll do then.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 10
    Last Post: 11-12-2014, 05:37 PM
  2. Excel object, copy and paste a worksheet
    By crowegreg in forum Programming
    Replies: 2
    Last Post: 05-28-2014, 12:04 PM
  3. Export Form And Subform Data To Excel Form Same Worksheet
    By tomtheappraiser in forum Import/Export Data
    Replies: 6
    Last Post: 08-12-2013, 10:39 AM
  4. Replies: 9
    Last Post: 06-21-2013, 08:22 PM
  5. Importing the second excel worksheet
    By geoffwbailey in forum Programming
    Replies: 1
    Last Post: 06-25-2010, 12:16 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums