Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Dynamic worksheet import to current workbook
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Dynamic worksheet import to current workbook
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 IntosH wrote: 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 -- Intos -- Anthony Prescott http://www.apofficesolutions.co.uk Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...mming/200902/1 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy worksheet into current workbook | Excel Discussion (Misc queries) | |||
Adding a worksheet to a current workbook | Excel Discussion (Misc queries) | |||
Adding a worksheet to a current workbook | Excel Discussion (Misc queries) | |||
Import multiple csv files into current workbook as separate sheets | Excel Programming | |||
How do I import an XLT worksheet into another workbook? | Excel Programming |