excel_vba_編程教程(完整版)、excel高級(jí)教程

1、Excel_VBA_編程教程(完整版)目錄一、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第八

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

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

8、.......................................................................4一Sub過(guò)程.................................................................4二Function函數(shù)............................................................5三Pro

9、perty屬性過(guò)程和Event事件過(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、.................................................11.4執(zhí)行宏..........................................................................................................................................21.5查看錄制的代碼...............

18、...........................................................................................................21.6編輯錄制的代碼......................................................................................................

19、....................31.7錄制宏的局限性..........................................................................................................................3Excel_VBA_編程教程(完整版)4.4.4使用數(shù)組......................................

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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