+ Reply to Thread
Results 1 to 2 of 2
  1. #1
    Registered User
    Join Date
    03-16-2010
    Location
    Dallas
    MS-Off Ver
    Excel 2007
    Posts
    1

    Copying a picture from another workbook VBA

    I have a workbook that houses a large macro that I would like to copy a picture from and place on a sheet in a new workbook. I don't have any issues with the VBA code in going back and forth between the worksheets. My problem is referring to the actual picture. Since the pictures "floats" on top of the cells, I can't hardly refer to the location (ie: Range("A1").Select). How can I refer to the picture?

    BTW, currently, the code is pulling the picture from a location on our network--which works fine--but, i want to be able to copy this picture correctly without having to access the network. Thanks!

  2. #2
    Valued Forum Contributor mdbct's Avatar
    Join Date
    11-11-2005
    Location
    CT
    MS-Off Ver
    2003 & 2007
    Posts
    843

    Re: Copying a picture from another workbook VBA

    Something like this perhaps:

    Code:
    Workbooks("Book2").Sheets("NewBook").Shapes("picture 1").Copy
    Workbooks("book3").Sheets("Sheet1").Range("h1").PasteSpecial

Thread Information

Users Browsing this Thread

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

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.2.0