Open or run a VBA macro from Python in order to fix poisiting

Asked Jun 02 '22 at 20:50

Active Jun 03 '22 at 09:01

Viewed 84 times

Sub MoveAndSizeWithCells()
    Dim xPic As Picture
    On Error Resume Next
    Application.ScreenUpdating = False
    For Each xPic In ActiveSheet.Pictures
        Pic.Placement = MoveAndSize
    Next
    Application.ScreenUpdating = True
    
End Sub

this was the code that i wanted to execute on some of my worksheets but through python I am not able to do this . can anybody plzz help

edited Jun 03 '22 at 09:01

Charlie Clark

18,477
4
49
55

asked Jun 02 '22 at 20:50

Ajay Dikondwar

2

Where is the python code you have tried?, it sounds like the code works fine, just not when using python to run it. – Ricardo A Jun 02 '22 at 21:18
yes the code works abolutely fine in vba just the cruck was that i wanted to get it done through my python which doesnt seem to be happeninhg – Ajay Dikondwar Jun 03 '22 at 10:25
https://stackoverflow.com/questions/19505676/use-python-to-write-vba-script – Ajay Dikondwar Jun 03 '22 at 10:26
can u plz help me fixig this issue . i am trying to get it done through above code – Ajay Dikondwar Jun 03 '22 at 10:27

Open or run a VBA macro from Python in order to fix poisiting

0 Answers0