copy a file several times, rename it and place in a specific folder

Hi All,

I want to be able to copy an excel file from a specific location (chosen by the user), and paste it a number of times (user would input this number say in cell ref a1) and then it would be pasted in to another specific folder (chosen by the user).

Would it be possible to do this (if not the above is fine).... so it copies a file (chosen by user), but the amount of times to copy it depends on how many entries are in a specific column which is also used to rename the files.

So in column A it would bring up the file, Column B would show what file it is to be renamed to and then the last column would be the target where this file needs to be copied and pasted to.

The number of entries of the names would determine the amount of files copied.

Thank you

Hi,

To copy a file, use FileCopy

Please Login or Register  to view this content.

source: http://msdn.microsoft.com/fr-fr/libr...=vs.90%29.aspx

To choose a file, useFileDialog(msoFileDialogFilePicker)
http://msdn.microsoft.com/en-us/libr...ice.11%29.aspx

To choose a folder it is similar but use FileDialog(msoFileDialogFolderPicker) instead of FileDialog(msoFileDialogFilePicker)

To loop on names use something like

Please Login or Register  to view this content.

where A12 is the first name location, the test i<1000 is optional

ben

Hi Ben,

How do I link the the copy file to the loop names?

In the loop, you can get the string of the name with

Please Login or Register  to view this content.

If the DestPath string does not finish with a backslash, use

Please Login or Register  to view this content.

If you are new to Excel programming, you can find many good links here >> http://www.excelforum.com/excel-prog...ml#post3414753