Hello There,
I have 2 workbooks, First.xlsm and Second.xlsm.
In the Second.xlsm, I would like to populate all the names of the worksheets from First.xlsm (This workbook is closed), into an Array
Could you please advice, how can this be achieved?
Thank you & regards,
Don