Hi,
I can develop using complex objects in VBA, one of the example is using the File system object which will enable to select files and folders and work the objects and the items in these collections. There are many more objects like these which make working with Microsoft Office fun.
Once I get the details of your project, I can share a detailed plan of the development and can also suggest you ways to make the solution all the more robust and flexible.
Thanks