I have multiple workbooks and worksheets and I need to create multiple objects for the same. Number of sheets are not finite but I want to use all objects at different scenarios. I tried to create dynamic objects but didn't help. Please suggest.
I am browsing these workbooks from a folder and their are saved from a different source. When I browse and open each workbooks from a folder, I want to set an object name to each workbook and worksheets within that workbook