Main Menu

BOM

Started by itsatom, April 18, 2017, 07:19:54 PM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

itsatom

Hello all,

I need help to use VBA to generate a visio report with custom a custom font size, autofit row heights and column widths for font size, and change the color to black and white.

Sub Report()

Visio.Application.Addons("VisRpt").Run ("/rptDefName=BOM /rptOutput=EXCEL_SHAPE")

End Sub

How would I edit this code to do such tasks?

Thank you,

itsatom