im trying to get a picture uploaded then rotated then set properties.
this gets my pic uploaded to the properties i want, but not rotated
<code class="_34q3PgLsx9zIU5BiSOjFoM" style="margin: 0px; padding: 0px; border: 0px; font-style: inherit; font-variant: inherit; font-stretch: inherit; font-size: 13px; line-height: 20px; font-family: "Noto Mono", Menlo, Monaco, Consolas, monospace; vertical-align: baseline; color: rgb(34, 34, 34); background: transparent; max-width: 100%; overflow: auto;"> Sub tyh()
ActiveSheet.Shapes.AddPicture _
Filename:="C:\Users\dovi.dovi-PC\Desktop\ads bh\IMG-7042.jpg", _
LinkToFile:=msoFalse, savewithdocument:=msoCTrue, _
Left:=1200, Top:=604, Width:=350, Height:=604
End Sub
</code>this gets the pic uploaded set the properties then rotates the pic
<code class="_34q3PgLsx9zIU5BiSOjFoM" style="margin: 0px; padding: 0px; border: 0px; font-style: inherit; font-variant: inherit; font-stretch: inherit; font-size: 13px; line-height: 20px; font-family: "Noto Mono", Menlo, Monaco, Consolas, monospace; vertical-align: baseline; color: rgb(34, 34, 34); background: transparent; max-width: 100%; overflow: auto;">
Sub tyh()
ActiveSheet.Shapes.AddPicture _
Filename:="C:\Users\dovi.dovi-PC\Desktop\ads bh\IMG-7042.jpg", _
LinkToFile:=msoFalse, savewithdocument:=msoCTrue, _
Left:=1200, Top:=604, Width:=350, Height:=604
ActiveSheet.Shapes(ActiveSheet.Shapes.Count).Rotation = 90
End Sub
</code>the problem is that i need the pic rotated first (bec. its not a square) then set the properties but whereever i try putting ......
<code class="_34q3PgLsx9zIU5BiSOjFoM" style="margin: 0px; padding: 0px; border: 0px; font-style: inherit; font-variant: inherit; font-stretch: inherit; font-size: 13px; line-height: 20px; font-family: "Noto Mono", Menlo, Monaco, Consolas, monospace; vertical-align: baseline; color: rgb(34, 34, 34); background: transparent; max-width: 100%; overflow: auto;">
ActiveSheet.Shapes(ActiveSheet.Shapes.Count).Rotation = 90
</code>
before the properties i get ERROR WRONG NUMBER OF ARGUMENTS OR INVALID PROPERTY ASSIGNMENT or SYNTAX ERROR
this gets my pic uploaded to the properties i want, but not rotated
<code class="_34q3PgLsx9zIU5BiSOjFoM" style="margin: 0px; padding: 0px; border: 0px; font-style: inherit; font-variant: inherit; font-stretch: inherit; font-size: 13px; line-height: 20px; font-family: "Noto Mono", Menlo, Monaco, Consolas, monospace; vertical-align: baseline; color: rgb(34, 34, 34); background: transparent; max-width: 100%; overflow: auto;"> Sub tyh()
ActiveSheet.Shapes.AddPicture _
Filename:="C:\Users\dovi.dovi-PC\Desktop\ads bh\IMG-7042.jpg", _
LinkToFile:=msoFalse, savewithdocument:=msoCTrue, _
Left:=1200, Top:=604, Width:=350, Height:=604
End Sub
</code>this gets the pic uploaded set the properties then rotates the pic
<code class="_34q3PgLsx9zIU5BiSOjFoM" style="margin: 0px; padding: 0px; border: 0px; font-style: inherit; font-variant: inherit; font-stretch: inherit; font-size: 13px; line-height: 20px; font-family: "Noto Mono", Menlo, Monaco, Consolas, monospace; vertical-align: baseline; color: rgb(34, 34, 34); background: transparent; max-width: 100%; overflow: auto;">
Sub tyh()
ActiveSheet.Shapes.AddPicture _
Filename:="C:\Users\dovi.dovi-PC\Desktop\ads bh\IMG-7042.jpg", _
LinkToFile:=msoFalse, savewithdocument:=msoCTrue, _
Left:=1200, Top:=604, Width:=350, Height:=604
ActiveSheet.Shapes(ActiveSheet.Shapes.Count).Rotation = 90
End Sub
</code>the problem is that i need the pic rotated first (bec. its not a square) then set the properties but whereever i try putting ......
<code class="_34q3PgLsx9zIU5BiSOjFoM" style="margin: 0px; padding: 0px; border: 0px; font-style: inherit; font-variant: inherit; font-stretch: inherit; font-size: 13px; line-height: 20px; font-family: "Noto Mono", Menlo, Monaco, Consolas, monospace; vertical-align: baseline; color: rgb(34, 34, 34); background: transparent; max-width: 100%; overflow: auto;">
ActiveSheet.Shapes(ActiveSheet.Shapes.Count).Rotation = 90
</code>
before the properties i get ERROR WRONG NUMBER OF ARGUMENTS OR INVALID PROPERTY ASSIGNMENT or SYNTAX ERROR
Last edited: