excel vba 完全教程

1、ExcelVBA目錄一、VBA語(yǔ)言基礎(chǔ)...................................................................................................................1第一節(jié)標(biāo)識(shí)符...............................................................................

2、.....................................................1第二節(jié)運(yùn)算符....................................................................................................................................1第三節(jié)數(shù)據(jù)類型....................

3、............................................................................................................1第四節(jié)變量與常量.......................................................................................................

4、.....................1第五節(jié)數(shù)組........................................................................................................................................2第六節(jié)注釋和賦值語(yǔ)句..............................................

5、......................................................................2第七節(jié)書(shū)寫(xiě)規(guī)范................................................................................................................................2第八節(jié)判斷語(yǔ)句......

6、..........................................................................................................................2第九節(jié)循環(huán)語(yǔ)句..........................................................................................

7、......................................3第十節(jié)其他類語(yǔ)句和錯(cuò)誤語(yǔ)句處理................................................................................................4第十一節(jié)過(guò)程和函數(shù)............................................................

8、............................................................4一Sub過(guò)程.................................................................4二Function函數(shù)............................................................5三Property屬性過(guò)程和E

9、vent事件過(guò)程.........................................5第十二節(jié)內(nèi)部函數(shù).............................................................................................................................5一測(cè)試函數(shù)...............................

10、.................................5二數(shù)學(xué)函數(shù)................................................................5三字符串函數(shù)..............................................................5四轉(zhuǎn)換函數(shù)..........................................

11、......................6五時(shí)間函數(shù)................................................................6第十三節(jié)文件操作.......................................................................................................................

12、.....6文件........................................................................6刪除........................................................................6打開(kāi)..............................................................

13、..........6讀入........................................................................7寫(xiě)入........................................................................7關(guān)閉.........................................................

14、...............7其他文件函數(shù)................................................................7二、VISUALBASIC程序設(shè)計(jì)網(wǎng)絡(luò)教學(xué).....................................................................................1第一課VBA是什么.................

15、................................................................................................11.1VBA是什么..................................................................................................................

16、..................11.2EXCEL環(huán)境中基于應(yīng)用程序自動(dòng)化的優(yōu)點(diǎn)................................................................................11.3錄制簡(jiǎn)單的宏........................................................................................

17、......................................14.4變量..............................................................................................................................................94.4.1變量的數(shù)據(jù)類型.....................

18、...................................94.4.2用Dim語(yǔ)句創(chuàng)建變量(聲明變量)..........................................104.4.3變量命名的慣例.......................................................104.4.4使用數(shù)組.........................................

19、....................104.4.5變量賦值.............................................................11第五課利用VBA設(shè)置工作表使用權(quán)限...................................................................................111使用WITH語(yǔ)句。..............

20、............................................................................2使用對(duì)象變量。.........................................................................................方法3：減少對(duì)象的激活和選擇.................................

21、...................................方法4：關(guān)閉屏幕更新....................................................................................第六課提高EXCEL中VBA的效率..........................................................................

22、..................12方法1：盡量使用VBA原有的屬性、方法和WKSHEET函數(shù)............................................................12方法2：盡量減少使用對(duì)象引用，尤其在循環(huán)中.........................................................................121使用With語(yǔ)句。...

23、.......................................................122使用對(duì)象變量。..........................................................123在循環(huán)中要盡量減少對(duì)象的訪問(wèn)。..........................................13方法3：減少對(duì)象的激活和選擇.....................

24、...............................................................................13方法4：關(guān)閉屏幕更新....................................................................................................................13第七課如何在EXCEL

25、里使用定時(shí)器.......................................................................................13三、學(xué)習(xí)微軟EXCEL2002VBA編程和XML，ASP技術(shù)...........................................................15第一章電子表格自動(dòng)化簡(jiǎn)介和了解宏命令................

26、...........................................................151了解宏............................................................................................................................................152宏命令的普通應(yīng)用....

27、....................................................................................................................153寫(xiě)宏之前的計(jì)劃..............................................................................................

28、..............................164錄制宏............................................................................................................................................175運(yùn)行宏......................................

29、......................................................................................................186修改宏代碼..............................................................................................................

30、......................197添加注釋........................................................................................................................................218分析宏代碼...............................................

31、.....................................................................................229清除宏代碼...............................................................................................................................

32、.....2310測(cè)試修改好的宏..........................................................................................................................2411兩個(gè)層面運(yùn)行宏的方法....................................................................

33、..........................................2412完善你的宏代碼..........................................................................................................................2513重新命名宏....................................

34、..............................................................................................2714運(yùn)行宏的其它方法..................................................................................................................