① excel琛ㄦ牸涓錛屼嬌鐢ㄥ畯錛屽備綍瀹炵幇鎶婁竴涓鏂囦歡鎷瘋礉鍒板彟澶栦竴涓鏂囦歡澶癸紵
鐢–opyfile鏂規硶鍙浠ュ疄鐜般
浠ｇ爜濡備笅錛
Set fs = CreateObject("Scripting.FileSystemObject")
fs.file 鍙傛暟1, 鍙傛暟2, 鍙傛暟3
鍏朵腑絎涓涓鍙傛暟鏄婧愭枃浠剁殑瀹屾暣璺寰勶紝濡傗淐:\users\administrator\Desktop\Book1.xls鈥濓紝絎浜屼釜鍙傛暟鏄鐩鏍囨枃浠跺す鐨勫畬鏁磋礬寰勶紝濡傗淐:\users\administrator\Desktop"錛岀涓変釜鏄鏄鍚﹁嗙洊宸插瓨鍦ㄧ殑鏂囦歡錛孴rue鎴栬匜alse錛孴rue琛ㄧず瑕嗙洊錛孎alse琛ㄧず涓嶈嗙洊銆
鍏充簬Copyfile鐨勭浉鍏崇煡璇嗭細
Copyfile錛氭妸涓涓鎴栧氫釜鏂囦歡浠庝竴涓鍦版柟澶嶅埗鍒板彟涓涓鍦版柟銆
璇娉
object.CopyFile source, destination[,
overwrite]
CopyFile 鏂規硶璇娉曟湁濡備笅鍑犻儴鍒嗭細
object
蹇呴渶鐨勩俹bject濮嬬粓鏄涓涓 FileSystemObject
鐨勫悕瀛椼
source
蹇呴渶鐨勩傛寚鏄庝竴涓鎴栧氫釜瑕佽澶嶅埗鏂囦歡鐨勫瓧絎︿覆鏂囦歡璇存槑錛屽畠鍙浠ュ寘鎷閫氶厤絎︺
destination
蹇呴渶鐨勩傛寚鏄 source
涓鐨勪竴涓鎴栧氫釜鏂囦歡瑕佽澶嶅埗鍒扮殑鎺ュ彈絝鐨勫瓧絎︿覆錛屼笉鍏佽告湁閫氶厤絎︺
overwrite
閫夐」鐨勩侭oolean 鍊礆紝瀹冭〃紺哄瓨鍦ㄧ殑鏂囦歡鏄鍚﹁瑕嗙洊銆傚傛灉鏄
True錛屾枃浠跺皢琚瑕嗙洊錛涘傛灉鏄 False錛屽畠浠涓嶈瑕嗙洊銆傜己鐪佸兼槸 True銆傛敞鎰忓傛灉 destination
鍏鋒湁鍙璇誨睘鎬ц劇疆錛屼笉璁 overwrite 鍊煎備綍錛孋opyFile 閮藉皢澶辮觸銆
② 鎬庢牱鐢–璇璦灝嗘枃浠跺嶅埗鍙﹀栫殑鏂囦歡澶
鏈変袱縐嶆柟寮忓彲浠ュ疄鐜板嶅埗錛
涓銆佽嚜琛岀紪鍐欏嚱鏁幫紝瀹炵幇澶嶅埗銆
綆楁硶嫻佺▼濡備笅錛
1 浠ヨ葷殑鏂瑰紡鎵撳紑婧愭枃浠錛屼互鍐欑殑鏂瑰紡鎵撳紑鐩鏍囨枃浠訛紱
2 姣忔¤諱竴涓瀛楄妭錛屽苟鍐欏埌鐩鏍囨枃浠朵腑錛岀洿鍒拌揪鍒鏂囦歡緇撳熬涓烘錛
3 鍏抽棴涓や釜鏂囦歡銆
浜屻佽皟鐢ㄧ郴緇熷懡浠ゃ
stdlib.h涓鐨剆ystem鍑芥暟錛屽彲浠ユ墽琛岀郴緇鍛戒護琛鏀鎸佺殑鍛戒護銆
int system(char *cmd);
璋冪敤鏃跺氨鏄鎵ц宑md涓鐨勬寚浠ゃ
1 瀵逛簬windows,灝辨槸鎵ц宒os鍛戒護錛屽彲浠ヨ皟鐢
system(" /Y src_file target_dir");
鍏朵腑src_file涓烘簮鏂囦歡錛岃宼arget_dir灝辨槸鐩鏍鏂囦歡澶銆
2 瀵逛簬Linux錛岄渶瑕佹墽琛宻hell鍛戒護cp錛屽備笅
system("cp src_file target_dir");