| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Creating and Naming a Folder and populating it with files
How can I, using VBA in Excel, create a New Folder, rename same, and transfer/copy some .xls files from another Folder to the newly created folder? TIA Myles -- Myles ------------------------------------------------------------------------ Myles's Profile: http://www.excelforum.com/member.php...o&userid=28746 View this thread: http://www.excelforum.com/showthread...hreadid=573527 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Creating and Naming a Folder and populating it with files
In article ,
says... How can I, using VBA in Excel, create a New Folder, rename same, and transfer/copy some .xls files from another Folder to the newly created folder? Search XL VBA help for the following (in each case, exclude the quotes): "make directory" "rename directory" "copy file" In each case, when looking at the result of the search, you are interested in a *statement* and not a method or a property. -- Regards, Tushar Mehta www.tushar-mehta.com Excel, PowerPoint, and VBA add-ins, tutorials Custom MS Office productivity solutions |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro creating folder and files automatically, without permission. | Excel Discussion (Misc queries) | |||
| Creating a List of the files in a folder in excel | Excel Discussion (Misc queries) | |||
| Creating and Naming a Folder and populating it with files | Excel Programming | |||
| Populating ComboBox with Folder Names | Excel Programming | |||
| creating an XLS file from " files" data in a Folder | Excel Discussion (Misc queries) | |||
![Myles[_79_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
