Hello,
I have a folder with several excel files (i.e. A.xls, B.xls, C.xls ...)
and I want to create a macro that depending on the text (referring an
excel file) in a determinate cell (A, B, C,...), the macro copy all the
worksheets from this file to the current workbook. I want to copy them
after the current worksheet. I also want that when you change the text
in the cell (i.e. for example from A to B) the macro eliminates all the
worksheets from the file A and copy the worksheets from file B.
Thank you


--
IntosH
------------------------------------------------------------------------
IntosH's Profile: http://www.thecodecage.com/forumz/member.php?userid=152
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=68960