Write Collection into Excel Macro file

[Antony_AkkaraJ]

How it is possible to write collection into EXCEL Macro file (*.xlsm) I tried, Create Instance --- Open Workbook --- Write Collection (it fails here)

[Hari_KrishnaJal]

Hi Antony, It's Working for me when writing collection to Excel(.xlsm) Spreadsheet. Please find imported xml file FYR. Let me know if this helps or need any further clarification. Thanks, Hari J