EBDN - Community - Question & Answers
Hello,
I am currently developing a Sheet copy feature in my Assistant.
My ultimate goal is to implement functionality equivalent to the Paste Special options when copying Sheets — specifically, to achieve the same result as the "Create additional representation of the same objects" behavior (Shift + Ctrl + Drag & Drop) shown in the attached image under [Shapes].
What I have tested so far:
- Using the `CopyTo2` method with the `aucCopyTMoveMerge` option
→ Objects without Function type and Designation are not merged; instead, completely new objects are created.
- Using the `aucCopyTCopyInterface` option
→ Results in a runtime error.
My questions are:
1. Is there an API / method that corresponds to Paste Special (Option: Same objects)?
2. If yes, could you please provide the exact method name and a working code example (preferably in VBA or .NET)?
Thanks in advance!
I am currently developing a Sheet copy feature in my Assistant.
My ultimate goal is to implement functionality equivalent to the Paste Special options when copying Sheets — specifically, to achieve the same result as the "Create additional representation of the same objects" behavior (Shift + Ctrl + Drag & Drop) shown in the attached image under [Shapes].
What I have tested so far:
- Using the `CopyTo2` method with the `aucCopyTMoveMerge` option
→ Objects without Function type and Designation are not merged; instead, completely new objects are created.
- Using the `aucCopyTCopyInterface` option
→ Results in a runtime error.
My questions are:
1. Is there an API / method that corresponds to Paste Special (Option: Same objects)?
2. If yes, could you please provide the exact method name and a working code example (preferably in VBA or .NET)?
Thanks in advance!