check this link:
http://www.freevbcode.com/ShowCode.a...499&NoBox=True
you can give the source file path and destination file path as arguments using the function in the above link.
If a user gives input as say 3 copies of file "count.xls", then use the copy function in loop and add a string to the filename every time it copies.
using the function from the link,
for i=1 to 3
shellfilecopy("c:\count.xls","f:\" & "count" & integer2string(i)& ".xls")
integer to string will be a function which will convert an integer to string.
hence u will get fiels of the name count1.xls,count2.xls,count3.xls
hope it helps