Hi all,

Got a large document doing various things - one of the first steps is using a command button that opens the file window, allows you to select multiple excel files and then they are consolidated and imported into another workbook, then various other stages through user form options etc for data analysis. I'm hitting a wall. I've highlighted code in bold, if that is removed then I get an error when closing the file window having not selected anything. If i have that in there, when I select my files an open I get a miss match error.

Anybody got any ideas?

Thanks.


Please Login or Register  to view this content.