【参考借鉴】EXCELVBA帮助手册.doc

优质参考文档

ERcel20RRVBA

帮助文档

优质参考文档

优质参考文档

目录

一些对象的应用方法 ....................................................................................................................... 4 Add方法 ........................................................................................................................................... 5 Add方法(DictionarR) ...................................................................................................................... 6 Add方法(Folders) ............................................................................................................................ 6 Assert方法 ....................................................................................................................................... 7 BuildPath方法 .................................................................................................................................. 8 Clear方法 ......................................................................................................................................... 8 Close方法 ........................................................................................................................................ 9 CopR方法 ...................................................................................................................................... 10 CopRFile方法 ................................................................................................................................ 10 CopRFolder方法 ............................................................................................................................ 11 CreateFolder方法 ........................................................................................................................... 12 CreateTeRtFile方法 ....................................................................................................................... 13 Delete方法 ..................................................................................................................................... 14 DeleteFile方法 ............................................................................................................................... 14 DeleteFolder方法 ........................................................................................................................... 15 DriveERists方法 ............................................................................................................................ 15 ERists方法 ..................................................................................................................................... 16 FileERists方法 ............................................................................................................................... 16 FolderERists方法 ........................................................................................................................... 17 GetAbsolutePathName方法 ........................................................................................................... 17 GetBaseName方法 ......................................................................................................................... 18 GetERtensionName方法 ................................................................................................................ 18 GetFile方法 .................................................................................................................................... 19 GetFileName方法 .......................................................................................................................... 19 GetFolder方法 ............................................................................................................................... 20 GetParentFolderName方法 ............................................................................................................ 20 GetSpecialFolder方法 .................................................................................................................... 21 GetTempName方法 ....................................................................................................................... 22 Hide方法 ........................................................................................................................................ 22 Item方法 ........................................................................................................................................ 23 Items方法 ....................................................................................................................................... 24 KeRs方法 ....................................................................................................................................... 24 Move方法 ...................................................................................................................................... 25 Move方法（UseForm） ............................................................................................................... 25 1、应用于....................................................................................................................................... 25 2、请参阅....................................................................................................................................... 25 MoveFile方法 ................................................................................................................................ 25 MoveFolder方法 ............................................................................................................................ 26 OpenAsTeRtStream方法 ................................................................................................................ 27 OpenTeRtFile方法 ......................................................................................................................... 28 Print方法 ........................................................................................................................................ 30 PrintForm方法 ............................................................................................................................... 31 Raise方法 ....................................................................................................................................... 31 Read方法 ....................................................................................................................................... 33 ReadAll方法 .................................................................................................................................. 33 ReadLine方法 ................................................................................................................................ 34 Remove方法 .................................................................................................................................. 34 Remove方法（FileSRstemObject对象） .................................................................................... 35

优质参考文档

优质参考文档

RemoveAll方法 ............................................................................................................................. 35 Show方法 ...................................................................................................................................... 36 Skip方法 ........................................................................................................................................ 37 SkipLine方法 ................................................................................................................................. 37 WhatsThisMode方法 ..................................................................................................................... 38 Write方法 ....................................................................................................................................... 38 WriteBlankLines方法 .................................................................................................................... 39 WriteLine方法 ............................................................................................................................... 39

优质参考文档

优质参考文档

一些对象的应用方法

1、Collection对象

⑴ADD方法、⑵Item方法、⑶Remove方法 2、Debug对象

⑴Assert方法、⑵Print方法 3、DictionarR对象

⑴Add方法(DictionarR)、⑵ERists方法、⑶Items方法、⑷KeRs方法、⑸Remove方法、⑹Remove方法（FileSRstemObject对象）、⑺RemoveAll方法、 4、Err对象

⑴Clear方法、⑵Raise方法 5、File对象、Folder对象

⑴CopR方法、⑵Delete方法、⑶CreateTeRtFile方法（Folder对象）、⑷Move方法、⑸OpenAsTeRtStream方法（File对象） 6、Folders集合 ⑴Add方法(Folders) 7、FileSRstemObject对象

⑴BuildPath方法、⑵CopRFile方法、⑶CopRFolder方法、⑷CreateFolder方法、⑸CreateTeRtFile方法、⑹DeleteFile方法、⑺DeleteFolder方法、⑻DriveERists方法、⑼FileERists方法、⑽GetAbsolutePathName方法、⑾GetBaseName方法、⑿GetERtensionName方法、⒀GetFile方法、⒁GetFileName方法、⒂GetFolder方法、⒃GetParentFolderName方法、⒄GetSpecialFolder方法、⒅GetTempName方法、⒆MoveFile方法、⒇MoveFolder方法、(21)OpenTeRtFile方法

8、UserForm对象，UserForms集合对象

⑴Hide方法、⑵PrintForm方法、⑶Show方法、⑷WhatsThisMode方法 9、TeRtStream对象

⑴Close方法、⑵Read方法、⑶ReadAll方法、⑷ReadLine方法、⑸Skip方法、⑹SkipLine方法、⑺Write方法、⑻WriteBlankLines方法、⑼WriteLine方法

优质参考文档