To Add or Insert Multiple objects from a folder in Microsoft Excel, you need to follow the steps below:
- Create the object of FileSystemObject(Link)
- Create Folder object using FileSystemObject and GetFolder (link) method and count the number of files.
- Get the files Object
- Run the Loop for each files in folder
- Insert the File objects , using OLE objects.
- Insert the added files name list in another sheet(just for reference)
- Save the workbook
Read moreVBA-Excel: Add/Insert multiple objects from a folder in an Excel Document.