Sunday 15 March 2015

VBA code to copy a file n number of times -



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