Excel Automation for Shapes

[vvaidya (Vinay Vaidya)]

Never done this, but will you be able to execute a macro inside the loop?

something like

ActiveSheet.Shapes("Rectangle 1")
        .Width = row("width").ToString()
        .Height = row("height").ToString()

Passing Argument to Excel Macro

Hi, You can make a call to the macro as follows: “Proc(”“Hello”“,8)” Considering Macro name is Proc and is accepting a string variable and integer variable. Thanks, Yuga