| 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 |
| 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 | |||
Threaded Mode
