Results 1 to 26 of 26

Thread: [RESOLVED] Copy 2 objects to clipboard at the same time

Threaded View

  1. Jan 7th, 2008, 02:13 PM #9
    Pirre001
    Pirre001 is offline

    Thread Starter
    Fanatic Member
    Join Date
    Jul 2002
    Posts
    665

    Re: Copy 2 objects to clipboard at the same time

    When I record a macro in excel and then copy two Object charts it looks like this:
    VB Code:
    1. ActiveSheet.Shapes.Range(Array("Object 2", "Object 1")).Copy
    But how can I do this from VB. I have two OLE with MsGraph in each one of them.
    Copy a chart from one OLE is no problem. But how can I copy both charts at the same time to clipboard?
    Copy one chart I do like this
    VB Code:
    1. Dim objGraph As Object

    2. Clipboard.Clear

    3. Set objGraph = Me.OLE1.object

    4. objGraph.ChartArea.Copy

    5. Set objGraph = Nothing
    Last edited by Pirre001; Jan 7th, 2008 at 02:17 PM.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width