Thank You Vry MuchHi @vinay
As VJR said, using macros is the easiest option to format the Excel workbook.
I've written a macro and you can use it to resize your excel worksheet.
Sub resize()
' resize Macro
Range("B12").Select
Columns("B:B").EntireColumn.AutoFit
End Sub
Just edit the Column B:B to A:A or C:C according to the column you want to resize or Autofit.
Then using the MS Excel VBO "Run Macro" you can use this macro in your BluePrism object.
Let me know if you have any further questions.
Hi VJ,
Apologies for the confusion caused.
The solution worked for me.
Thanks!
Hello,
I wrote the below macro to Autofit the columns.
Sub resize()
' resize Macro
Range("A1").Select
Columns("A:C").EntireColumn.AutoFit
Range("E1").Select
Columns("E:L").EntireColumn.AutoFit
With Worksheets("Sheet1").Columns("D")
.ColumnWidth = .ColumnWidth + 10
End With
End Sub
Range, you can specify as per your requirements.
Then using the MS Excel VBO "Run Macro" I gave this macro in my BluePrism object.
I have attached the Run Macro Action properties for your reference.
Thanks!