I'm new to VBA so I'm not pretty sure what I'm doing. Please be kind.
What I'm trying to implement is, user select the files from File Picker and put the selected files' path into ArrayList. I created fileList as global variable then initialize it in Workbook_Open event.
I'm getting Object variable or With block variable not set error in adding String into the ArrayList.
Please Login or Register to view this content.
Bookmarks