Copy and paste image to Word and rotate it

[Menohavename]

Hi,

this forum has proven as a great source of help for my project, thank you all very much! I'd like to challenge you with another problem.
I would like to copy a table from Excel, paste it in a Word file and then rotate it 90 degrees. I tried various methods that I found online but they mostly explain how to do it after using .Add and not after pasting from Excel, and the solutions posted there have not worked yet for me.

A minimal example of my code is:

Please Login or Register  to view this content.

I also tried variations of this such as wdRng.IncrementRotation -90, wd.Rng.Select Selection.IncrementRotation -90, and others - unsuccessful so far.


I hope you can help me out once more with this one.

PS: Happy Easter to everyone and stay healthy!

[Menohavename]

Nobody with an idea here?

[Andy Pope]

The syntax would be

Please Login or Register  to view this content.

your code assumes the recently pasted item is the first item in the inlineshapes collection. If you have no others it will be but you may need to use the last shape in the collection.

[Menohavename]

The syntax would be

Please Login or Register  to view this content.

Okay, now I feel stupid for asking the question. I tried various codes but this one I did not and it works perfectly, thank you!

your code assumes the recently pasted item is the first item in the inlineshapes collection.

Thank you also for this hint but that's inteded, it is the only inlineshape, indeed, so it's fine.