Hello:

I have a small Excel project that I'm working on. Here is what I need to do. I have Excel files that have the same format, all tab:cell contains the same kind of information, just different values.

What I need to do is to extract the values from different cells and format them into a table. There are two cells I use containing the following information: a folder, file name. I am entering those information manually by copy/paste. It is working as of now but I want to make it more easlier.

Can I drop a file into an Excel object so it will extra the folder and file name into these two cells? I have heard that Treeview works but I did not really follow how to set it up.

thanks