Copy and Paste Folder With VBA

HI
it is possible. Need more details to give you specific codes
Ravi

Thanks for the reply

Basically i have a folder of files which are a sort of template. i want to be able to copy the whole folder and rename the folder.

example.

if the folder was c:/myFiles/template/

i want to copy and paste the folder template and rename the folder (again, if possible) using the value in cell A1 (which would probably have a name serial for example).

i would end up with
c:/myFiles/templateRenamed/

i hope that makes sense, if not please just let me know.

Thanks in advance!
cj

Moving a folder is the same as renaming it. No copy is needed.

Here are 2 routines to play with. Be sure to backup your folders before attempting this. Some of these require a trailing "\" and some do not.

Be sure to first add the reference in Tools > Reference, since they use the early binding method.

Please Login or Register  to view this content.

Hello cjconner24,

I wasn't sure exactly what you wanted to do, so I created a flexible macro that should do what you need. The macro uses late binding so you don't need to add a library reference to your project. This also allows the code to run directly on other machines. This macro allows you to rename a folder, or copy a folder to a new location, and lets you choose if the files in the folder will be overwritten when the folder is copied. The macro assumes the existence of a destination folder. It will not create one for you.

This macro has 3 arguments. The first argument is required and is the source file path. The second argument, which is optional, is the destination folder path. The source will be copied to the destination and renamed using the text of cell "A1". The third argument, which is optional, determines if the folder will overwrite th files in it. The default is False. You can change the cell that contains the new folder name by changing the variable NewName in the code. All error checking and handling is done in the macro.

Please Login or Register  to view this content.

Adding the Macro
1. Copy the macro above pressing the keys CTRL+C
2. Open your workbook
3. Press the keys ALT+F11 to open the Visual Basic Editor
4. Press the keys ALT+I to activate the Insert menu
5. Press M to insert a Standard Module
6. Paste the code by pressing the keys CTRL+V
7. Make any custom changes to the macro if needed at this time
8. Save the Macro by pressing the keys CTRL+S
9. Press the keys ALT+Q to exit the Editor, and return to Excel.

Examples

Please Login or Register  to view this content.

Thanks for all the great help. This is exactly what i was after

Hello,

I am trying to accomplish exactly what cjconnor24 was. I have used Leith Ross's code, and it's almost perfect except I can't get it to work exactly how it is supposed to.

When i use the code exactly as written; instead of copying "C:\myfiles\template" to "C:\temp" directory and then renaming the new "template" folder = Range("A1").text, what it does is copy the "C:\myfiles\template" to "C:\temp", and then renames "C:\temp" = Range("A1").text.

Any help on why this is not working correctly for me would really be appreciated.

I have the same problem as Zorgunfleck!

I was trying to use Leith Ross's code. By exactly copying the code, how do I put source and destination path. Basically how to put runtime argument values.