any easy fast possible way to group all these business cards separately. https://we.tl/tylZcTY3p6
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29
Sub group_on_selected_rectangles() Dim srRectangles As ShapeRange Dim sRect As Shape On Error GoTo ErrHandler ActiveDocument.BeginCommandGroup "Group objects on selected rectangles" EventsEnabled = False Optimization = True Set srRectangles = ActiveSelectionRange For Each sRect In srRectangles ActivePage.SelectShapesFromRectangle sRect.LeftX, sRect.BottomY, sRect.RightX, sRect.TopY, False ActiveSelectionRange.Group Next sRect ExitSub: Optimization = False EventsEnabled = True ActiveDocument.EndCommandGroup Refresh Exit Sub ErrHandler: MsgBox "Error occurred: " & Err.Description Resume ExitSub End Sub
Eskimo,
I hope you do not mind, I have changed your code a little bit. I added some CQL to find all other shapes the same size as the original one selected.
Happy Coding,
-Shelby
Sub group_on_selected_rectangles() Dim srSelection As ShapeRange, srRectangles As ShapeRange Dim sRect As Shape Set srSelection = ActiveSelectionRange If srSelection.Shapes.Count > 1 Then MsgBox "Please only select one shape.": Exit Sub On Error GoTo ErrHandler ActiveDocument.BeginCommandGroup "Group objects on selected rectangles" EventsEnabled = False Optimization = True Set srRectangles = ActivePage.Shapes.FindShapes(Query:="@width = {" & srSelection(1).SizeWidth & " in } and @height ={" & srSelection(1).SizeHeight & " in }") For Each sRect In srRectangles ActivePage.SelectShapesFromRectangle sRect.LeftX, sRect.BottomY, sRect.RightX, sRect.TopY, False ActiveSelectionRange.Group Next sRect ExitSub: ActiveDocument.ClearSelection Optimization = False EventsEnabled = True ActiveDocument.EndCommandGroup Refresh Exit Sub ErrHandler: MsgBox "Error occurred: " & Err.Description Resume ExitSub End Sub
No offense taken, Shelby!
I considered doing that, but came down on the side of "expose them to the benefits of Select Same" instead.
Seeing both ways? Even better.
1 more issue with this design please help in that too
if i change size of business card of entire last row below shown issue comes up why?
this issue comes in top rows as well but not on every card thats why i mentioned only last row
How to"change size of business card of entire last row "? All the logic of the above presented code selects and groups only the shapes INSIDE THE SAME DIMENSIONS SHAPE as the initially selected one.
Besides that I can not understand what really happens... Can you post a link to that specific file behaving in that way? Maybe after testing it I will understand what do you mean and maybe why that behavior.
https://we.tl/tylZcTY3p6
I tested the file and everything runs smooth... Corel X8 64 bit.
Al the shapes in the wished rectangle area are well grouped. Any not grouped shape remained. I cannot reproduce your problem. Are you sure that you sent that file? You mentioned something about "if i change size of business card of entire last row". What did you mean? The shapes in the last row have the same dimensions like the rest of them...
Looking to your sample picture shell I understand that the last some shapes disappear and instead of them you have that long triangle?
Some of the PowerClip frames are Curves, not Rectangles.
If I select one of those and try to resize it, it does something like this:
VIDEO:crazy curve.
i am using x6 64bit
if i change size of business card of last row mean
i am changing size of all business card 1 by 1 of last row.
yes it become like a triangle or something like that sometime triangle in bottom direction just like in the picture and sometime triangle become in upper direction.
exactly this was that issue sir any solution for this?
Ouch! I was thinking that the problem appears after running the macro...
It is very strange indeed.
What I have in mind now would be to identify that strange powerClip shape and do some tricks in order to replace it with a real rectangle: check if powerClip Parent is a curveShape, put in variables the position and dimensions of the actual powerClip Curve, put in a variable the shape range inside powerclip, extract shapes from powerclip, delete powerclip parent, create a rectangle having the same dimensions in the same position and add extracted shapes to the new rectangle. It should not be so complicated I think...
I will come back with a piece of code doing that. I hope in some minutes...
I did something much like that yesterday evening...
Sub make_powerclips_rectangles() Dim sr As ShapeRange Dim s1 As Shape Dim s2 As Shape Dim srExtracted As ShapeRange Set sr = ActivePage.Shapes.FindShapes(Query:="!@com.powerclip.IsNull") For Each s1 In sr Set s2 = ActiveLayer.CreateRectangleRect(s1.BoundingBox) s2.Outline.Color = s1.Outline.Color s2.Outline.Width = s1.Outline.Width Set srExtracted = s1.PowerClip.ExtractShapes s1.Delete srExtracted.AddToPowerClip s2 Next s1 End Sub