VBA
鍏ラ棬绯诲垪璁插骇
1.1
V
BA
鏄粈涔?/p>
鐩村埌
90
骞翠唬鏃╂湡
,
浣垮簲鐢ㄧ▼搴忚嚜鍔ㄥ寲杩樻槸鍏呮弧鎸戞垬鎬х殑棰嗗煙
.
瀵规瘡涓渶瑕佽嚜鍔ㄥ寲鐨勫簲鐢?/p>
绋嬪簭
,
浜轰滑涓嶅緱涓嶅涔犱竴绉嶄笉鍚岀殑鑷姩鍖栬瑷�
.
渚嬪
:
鍙互鐢?/p>
excel
鐨勫畯璇█鏉ヤ娇
excel
鑷姩鍖?/p>
,
浣跨敤
word BASIC
浣?/p>
word
鑷姩鍖?/p>
,
绛夌瓑
.
寰蒋鍐冲畾璁╁畠寮�鍙戝嚭鏉ョ殑搴旂敤绋嬪簭鍏变韩涓�绉嶉�氱敤鐨?/p>
鑷姩鍖栬瑷�
--------Visual Basic For Application(VBA),
鍙互璁や负
VBA
鏄潪甯告祦琛岀殑搴旂敤
绋嬪簭寮�鍙戣瑷�
VASUAL BASIC
鐨勫瓙闆?/p>
.
瀹為檯涓?/p>
VBA
鏄�濆瘎鐢熶簬鈥?/p>
VB
搴旂敤绋嬪簭鐨勭増鏈?/p>
.VBA
鍜?/p>
VB
鐨勫尯鍒寘鎷涓嬪嚑涓柟闈?/p>
:
1. VB
鏄璁＄敤浜庡垱寤烘爣鍑嗙殑搴旂敤绋嬪簭
,
鑰?/p>
VBA
鏄娇宸叉湁鐨勫簲鐢ㄧ▼搴?/p>
(excel
绛?/p>
)
鑷姩鍖?/p>
2. VB
鍏锋湁鑷繁鐨勫紑鍙戠幆澧?/p>
,
鑰?/p>
VBA
蹇呴』瀵勭敓浜庡凡鏈夌殑搴旂敤绋嬪簭
.
3.
瑕佽繍琛?/p>
VB
寮�鍙戠殑搴旂敤绋嬪簭
,
鐢ㄦ埛涓嶅繀瀹夎
VB,
鍥犱负
VB
寮�鍙戝嚭鐨勫簲鐢ㄧ▼搴忔槸鍙墽琛?/p>
鏂囦欢
(*.EXE),
鑰?/p>
VBA
寮�鍙戠殑绋嬪簭蹇呴』渚濊禆浜庡畠鐨勨�濈埗鈥濆簲鐢ㄧ▼搴?/p>
,
渚嬪
excel.
灏界瀛樺湪杩欎簺涓嶅悓
,VBA
鍜?/p>
VB
鍦ㄧ粨鏋勪笂浠嶇劧鍗佸垎鐩镐技
.
浜嬪疄涓?/p>
,
濡傛灉浣犲凡缁忎簡瑙ｄ簡
VB,
浼氬彂鐜板涔?/p>
VBA
闈炲父蹇?/p>
.
鐩稿簲鐨?/p>
,
瀛﹀畬
VBA
浼氱粰瀛︿範
VB
鎵撲笅鍧氬疄鐨勫熀纭�
.
鑰屼笖
,
褰撳浼氬湪
excel
涓?/p>
鐢?/p>
VBA
鍒?/p>
寤?/p>
瑙?/p>
鍐?/p>
鏂?/p>
妗?/p>
鍚?/p>
,
鍗?/p>
宸?/p>
鍏?/p>
澶?/p>
鍦?/p>
word
access
OUTLOOK
FOXPRO
PROWERPOINT
涓敤
VBA
鍒涘缓瑙ｅ喅鏂规鐨勫ぇ閮ㄥ垎鐭ヨ瘑
.
飦?/p>
VBA
涓�涓叧閿壒寰佹槸浣犳墍瀛︾殑鐭ヨ瘑鍦ㄥ井杞殑涓�浜涗骇鍝佷腑鍙互鐩镐簰杞寲
.
飦?/p>
VBA
鍙互绉颁綔
excel
鐨勨�滈仴鎺у櫒鈥?/p>
.
VBA
绌剁珶鏄粈涔?/p>
?
鏇寸‘鍒囧湴璁?/p>
,
瀹冩槸涓�绉?/p>
鑷姩鍖栬瑷�
,
瀹冨彲浠ヤ娇甯哥敤鐨勭▼搴忚嚜鍔ㄥ寲
,
鍙互