① 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");