Dynamic worksheet import to current workbook

[IntosH]

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 a
excel file) in a determinate cell (A, B, C,...), the macro copy all th
worksheets from this file to the current workbook. I want to copy the
after the current worksheet. I also want that when you change the tex
in the cell (i.e. for example from A to B) the macro eliminates all th
worksheets from the file A and copy the worksheets from file B.
Thank yo

 

[Crowbar via OfficeKB.com]

your description is vague! i dont understand what you mean!

It looks like you require some sort of automation

my company might be able to help

www.apofficesolutions.co.uk

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 a
excel file) in a determinate cell (A, B, C,...), the macro copy all th
worksheets from this file to the current workbook. I want to copy the
after the current worksheet. I also want that when you change the tex
in the cell (i.e. for example from A to B) the macro eliminates all th
worksheets from the file A and copy the worksheets from file B.
Thank yo

--
Anthony Prescott
http://www.apofficesolutions.co.uk

Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.aspx/excel-programming/200902/1