Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi Everyone,
I'm looking for help with a macro to move some Worksheets from one folder to another (i.e. cut & paste). The destination folder will need to also be created by the Macro. In english, the macro will need to: * Search through ThisWorkbook.Path for files called SOMETHING - Exceptions.xls e.g. Workbook 1 - Exceptions.xls, Smith - Exceptions.xls etc. etc. * Create a directory called "Exceptions" in ThisWorkbook.Path * Move all the files found with the name above into this Exceptions folder, leaving all other excel workbooks here with different names. Any help is greatfully received. Thanks!! Dave |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Move worksheets into separate workbooks | New Users to Excel | |||
How do I stop making the spreadsht move when I move up/dwn/lt/rt? | Excel Worksheet Functions | |||
How can I move multiple linked workbooks between computers | Excel Discussion (Misc queries) | |||
How do you move names and data between large Excel 2003 workbooks? | Excel Worksheet Functions | |||
How do I move workbooks w/o having to reset the links? | New Users to Excel |