VBA code to copy a file n number of times -
i want re-create file , write usb 30 times. code follows
sub test() dim fso object set fso = createobject("scripting.filesystemobject") = 1 30 fso.copyfile "system_path", "usb_path", false next end sub
my problem if set overwrite field false, error 'file exists'. if set true(or leave field blank), file copied once. how can re-create , write same file n number of times. in advance.
vba copy-paste
No comments:
Post a Comment