请问怎样才能把一个完整文件放到EXCEL表格中？ ..呢》
excel\u5982\u4f55\u51e0\u4e2aexcel\u8868\u683c\u653e\u5728\u4e00\u4e2a\u6587\u4ef6\u91cc\u9762\uff1f1\u3001\u9700\u8981\u628a\u591a\u4e2aexcel\u8868\u90fd\u653e\u5728\u540c\u4e00\u4e2a\u6587\u4ef6\u5939\u91cc\u9762\uff0c\u5e76\u5728\u8fd9\u4e2a\u6587\u4ef6\u5939\u91cc\u9762\u65b0\u5efa\u4e00\u4e2aexcel\u3002\u5982\u56fe\u6240\u793a\u3002
2\u3001\u6253\u5f00\u65b0\u5efa\u7684excel\u8868\uff0c\u5e76\u53f3\u952e\u5355\u51fbsheet1\uff0c\u627e\u5230\u201c\u67e5\u770b\u4ee3\u7801\u201d\uff0c\u5355\u51fb\u8fdb\u53bb\u3002\u8fdb\u53bb\u4e4b\u540e\u5c31\u770b\u5230\u4e86\u5b8f\u8ba1\u7b97\u754c\u9762\u3002\u5982\u56fe\u6240\u793a\u3002
3\u3001\u7136\u540e\u628a\u4e0b\u9762\u8fd9\u4e9b\u5b8f\u8ba1\u7b97\u7684\u4ee3\u7801\u590d\u5236\u8fdb\u53bb\uff0c\u7136\u540e\u627e\u5230\u5de5\u5177\u680f\u4e0a\u9762\u7684\u201c\u8fd0\u884c\u201d\u4e0b\u7684\u201c\u8fd0\u884c\u5b50\u8fc7\u7a0b/\u7528\u6237\u7a97\u4f53\u201d\uff0c\u4ee3\u7801\u5982\u4e0b\uff0c\u5982\u56fe\u6240\u793a\uff1a
Sub \u5408\u5e76\u5f53\u524d\u76ee\u5f55\u4e0b\u6240\u6709\u5de5\u4f5c\u7c3f\u7684\u5168\u90e8\u5de5\u4f5c\u8868()
Dim MyPath, MyName, AWbName
Dim Wb As Workbook, WbN As String
Dim G As Long
Dim Num As Long
Dim BOX As String
Application.ScreenUpdating = False
MyPath = ActiveWorkbook.Path
MyName = Dir(MyPath & "\" & "*.xls")
AWbName = ActiveWorkbook.Name
Num = 0
Do While MyName ""
If MyName AWbName Then
Set Wb = Workbooks.Open(MyPath & "\" & MyName)
Num = Num + 1
With Workbooks(1).ActiveSheet
.Cells(.Range("B65536").End(xlUp).Row + 2, 1) = Left(MyName, Len(MyName) - 4)
For G = 1 To Sheets.Count
Wb.Sheets(G).UsedRange.Copy .Cells(.Range("B65536").End(xlUp).Row + 1, 1)
Next
WbN = WbN & Chr(13) & Wb.Name
Wb.Close False
End With
End If
MyName = Dir
Loop
Range("B1").Select
Application.ScreenUpdating = True
MsgBox "\u5171\u5408\u5e76\u4e86" & Num & "\u4e2a\u5de5\u4f5c\u8584\u4e0b\u7684\u5168\u90e8\u5de5\u4f5c\u8868\u3002\u5982\u4e0b\uff1a" & Chr(13) & WbN, vbInformation, "\u63d0\u793a"
End Sub
4\u3001\u8fd0\u884c\u4e4b\u540e\uff0c\u7b49\u5f8510\u79d2\u9488\u5de6\u53f3\uff0c\u7b49\u8fd0\u884c\u5b8c\u6bd5\uff0c\u5c31\u662f\u5408\u5e76\u5b8c\u6210\u4e4b\u540e\uff0c\u4f1a\u6709\u63d0\u793a\uff0c\u70b9\u786e\u5b9a\u5c31\u53ef\u4ee5\u4e86\u3002\u67e5\u770b\u5408\u5e76\u540e\u7684\u6570\u636e\uff0c\u67095000\u591a\u884c\uff0c\u5c31\u662f\u540c\u4e00\u4e2a\u6587\u4ef6\u5939\u91cc\u976217\u4e2aexcel\u8868\u6570\u636e\u5408\u5e76\u540e\u7684\u7ed3\u679c\u3002\u6548\u679c\u5982\u56fe\u6240\u793a\u3002
\u4f7f\u7528\u7535\u5b50\u8868\u683c\u5de5\u5177\u7bb1\u91cc\u7684\u8868\u683c\u5408\u5e76\u529f\u80fd\uff0c\u6216\u5176\u5b83\u8f6f\u4ef6\u3002\u8981\u7684\u8bdd\u7ed9\u4f60\u4e00\u4e2a
使用超链接链接，但是发东西的时候，该附属的资料也要戴上插入，超连接
是指插入“对象”吗。
如果是要做出这样的效果的：
可以通过“插入——对象”，这样添加进行。
绛旓細杩欑鎯呭喌涓鑸湁浠ヤ笅鍑犵锛1銆佹枃浠跺凡琚牬鍧忥紝鍦ㄧЩ鍔ㄧ殑鏃跺欏嚭鐜伴棶棰橈紝杩欑鎯呭喌鍙兘閲嶆柊澶嶅埗涓閬銆2銆佽閿欎簡鎴栬呮搷浣滅殑鏃跺欙紝涓嶅皬蹇冪Щ鍔ㄥ埌鍒殑鍦版柟浜嗐備綘鍦ㄥ埆鐨勬枃浠跺す涓啀閲嶆柊閫夋嫨 涓涓嬨3銆佹枃浠跺凡缁忚闅愯棌锛屾壘鍒版枃浠跺す閫夐」璁剧疆鏄剧ず鍏ㄩ儴鏂囦欢澶广傚鏋滈兘涓嶆槸杩欎笁涓儏鍐碉紝閭ｄ及璁″氨鏄數鑴戝嚭鐜伴棶棰樹簡锛屽鏋滄枃浠...
绛旓細浣跨敤瓒呴摼鎺ラ摼鎺锛屼絾鏄彂涓滆タ鐨勬椂鍊欙紝璇ラ檮灞炵殑璧勬枡涔熻鎴翠笂
绛旓細1.鍙互鐢ㄥ帇缂╄蒋浠銆傜櫨搴︿竴鎼滅储鏈夊緢澶氥2.閫変腑浣犳兂瑕佸帇缂╃殑鏂囦欢鐒跺悗锛氱偣鍑诲彸閿啋娣诲姞鍒板帇缂╂枃浠讹紙A..)(杩欎釜鏃跺欎細寮瑰嚭鏂扮獥鍙ｏ級锛屽帇缂╂柟寮忛夋嫨鏈濂斤紙鍙互涓嶉夋嫨锛夛紝鍘嬬缉鍒嗗嵎澶у皬杩欎釜閫夐」锛堝彲浠ョ偣鍑讳笁瑙掔鍙烽夋嫨銆傦級鍏朵粬涓嶇敤閫夐」涓嶇敤绠★紝鐐圭‘瀹氬氨OK浜嗐傛敞锛氭垜鐢佃剳鏄疻IN7绯荤粺锛岀偣鍙抽敭鏄病鏈変笂杩扮2椤圭殑鍔...
绛旓細1銆佸亣璁炬湁涓や釜excel鏂囦欢鍒嗗埆涓篈鏂囦欢鍜孊鏂囦欢 2銆佸皢A鏂囦欢鐨1宸ヤ綔琛ㄧЩ鍔ㄥ埌B鏂囦欢涓 3銆佹墦寮A鏂囦欢骞跺彸閿偣鍑1宸ヤ綔琛 4銆侀夋嫨绉诲姩鑷冲伐浣滅翱B 5銆佺Щ鍔ㄥ畬涔嬪悗灏卞彲浠ョ湅鍒版晥鏋 濡傛灉鏄灏嗕竴涓Excel鏂囦欢涓殑涓寮犺〃澶嶅埗鍒板彟澶栦竴涓狤xcel鏂囦欢锛氭墦寮涓や釜鏂囦欢锛岄変腑婧愭枃浠朵腑瑕佸鍒剁殑琛ㄦ爣绛撅紝鍙抽敭鑿滃崟锛岀Щ鍔ㄦ垨澶嶅埗锛屽湪...
绛旓細锛1銆佹墦寮闇瑕佸鍒舵枃瀛楃殑word鏂囨。锛岄殢鍚庝娇鐢ㄥ揩鎹烽敭鈥淐trl+A鈥濆叏閫夊唴瀹癸紝闅忓悗鈥淐trl+C鈥濆鍒跺唴瀹銆2銆佹墦寮闇瑕佺矘璐寸殑word鏂囨。锛屼娇鐢ㄥ揩鎹烽敭鈥淐trl+V鈥濈矘璐达紝鎺ョ潃鐐瑰嚮绮樿创閫夐」灏忔銆3銆佸湪鎺ョ潃寮瑰嚭鐨勪笅鎷夎彍鍗曚腑鐐瑰嚮淇濈暀婧愭牸寮忔寜閽4銆侀殢鍚庡嵆鍙湅鍒板師鏉ョ殑琛ㄦ牸銆佸瓧浣撱佹枃瀛楀叏閮ㄩ兘娌℃湁鍙戠敓鍙樺寲銆
绛旓細1.鎶婁袱涓狤xcel鏂囦欢閮芥墦寮 2.鍒囨崲鍒拌澶嶅埗鐨勫伐浣滆〃锛屽彸閿伐浣滆〃鍚嶇О锛岄夋嫨绉诲姩鎴栧鍒跺伐浣滆〃銆3.閫夋嫨瑕佺Щ鍏ョ殑宸ヤ綔钖勶紝濡傛灉鏄鍒惰繃鍘荤殑璇濆簲鍕鹃夊缓绔嬪壇鏈紝鐐瑰嚮纭瀹屾垚宸ヤ綔琛ㄥ鍒躲
绛旓細1銆侀鍏堟墦寮鑷繁鎵嬫満鐨勮缃紝濡備笅濡傚浘鎵绀恒傚湪璁剧疆閲岄潰鐐瑰嚮鍌ㄥ瓨銆傦紝濡備笅鍥炬墍绀恒傚湪鍌ㄥ瓨閲岄潰鐪嬪埌榛樿鍌ㄥ瓨浣嶇疆鏄唴閮ㄥ偍瀛橈紝濡備笅鍥炬墍绀恒傜劧鍚庡湪鎵撳紑鐨勭獥鍙ｄ腑锛岀偣鍑诲唴閮ㄥ偍瀛橈紝鎶奡D鍌ㄥ瓨鍗＄偣浜傦紝濡備笅鍥炬墍绀恒2銆佸厛涔颁釜璇诲崱鍣ㄣ傜劧鍚庢妸鏈夋枃浠剁殑鍐呭瓨鍗℃彃鍦ㄨ鍗″櫒閲岋紝鐒跺悗鎶婅鍗″櫒鎻掑湪鐢佃剳涓婏紝鎶婃枃浠鎷峰埌鐢佃剳銆傜劧...
绛旓細灏嗗椤礟DF瀹屾暣鍦版彃鍏ュ埌Word鏂囨。涓紝鍙互鍊熷姪Word鐨勨滄彃鍏ュ璞♀濆姛鑳姐傞鍏堬紝鎵撳紑Word鏂囨。锛屾壘鍒伴《閮ㄨ彍鍗曚腑鐨勨滄彃鍏モ濋夐」锛岀劧鍚庡湪涓嬫媺鑿滃崟涓夋嫨鈥滃璞♀濄傛帴涓嬫潵锛屼綘闇瑕侀夋嫨鈥滄枃浠朵腑鐨勬枃瀛椻濋夐」锛岃繖浼氭墦寮涓涓枃浠閫夋嫨妗嗐傚湪杩欎釜妗嗕腑锛屽畾浣嶅苟閫夋嫨浣犳兂瑕佹彃鍏ョ殑PDF鏂囦欢锛岀劧鍚庣偣鍑烩滄彃鍏モ濇寜閽傛鏃讹紝Word...
绛旓細浠庢湇鍔″櫒涓婂鍒朵笅鏉ワ紝濡傛灉娌℃湁鏉冮檺鐨勮瘽锛屽彲浠ョ敤缃戠珯鏁寸珯涓嬭浇鐨勫伐鍏蜂笅杞戒笅鏉 缃戠珯鏁寸珯涓嬭浇鍣 http://www.onegreen.net/Soft_Show.asp?SoftID=5574
绛旓細闂涓锛鎬庝箞鎶鏂囦欢鍘嬬缉鍒版闈笂锛 鍙抽敭鐐瑰嚮閭ｄ釜鏂囦欢鎵鍦ㄧ殑鏂囦欢澶 娣诲姞鍒板帇缂╂枃浠 鏂瑰紡閫夋嫨鏈濂 鐐逛笂鍒涘缓鍥哄鍘嬬缉鏂囨。 鐒跺悗娴忚閫夋嫨妗岄潰灏辫 闂浜岋細鎬庝箞鎶婃闈㈢殑鏂囦欢鍘嬬缉鍒颁竴涓 鍚ч渶瑕佸帇缂╃殑鏂囦欢鏀惧湪涓涓鏂囦欢澶归噷锛屽彸閿紞鍘嬬缉锛嶈阿璋紞璇烽噰绾 闂涓夛細鎬庝箞鎶婂帇缂╂枃浠舵斁鍦ㄦ闈笂 鍏ㄩ夊嚑涓缉鍖咃紝鍙抽敭...
