vba Createobject可以创建的常用对象有: |
creatobject( "adodb.recordset" ) 数据库记录操作 |
creatobject( "scripting.filesystemobject" ) 文件操作 |
creatobject( "wscript.shell" ) SHELL creatobject( "wscript.network" ) 网络操作 |
createobject( "microsoft.xmlhttp" ) XMLHTTP ,远程获取文件用的 |
createobject ( "msxml2.xmlhttp.4.0" ) 同上 |
createobject( "adodb.stream" ) 数据流传输 |
createobject( "adodb.connection" ) 数据库连接 |
createobject ( "word. application " ) WORD |
createobject ( "excel. application " ) EXCEL |
createobject ( "mswc.adrotator" ) 广告 |
createobject( "scripting.dictionary" ) ’HASH表操作字典 |
createobject( "powerpoint.application" ) |
createobject( "Microsoft.XMLDOM" ) XML操作 |
createobject( "WScript.Shell" ) |
createobject( "wscript.network" ) |
createobject( "MSWC.adRotator" ) |
createobject( "excel.sheet" ) |
createobject( "frontpage.application" ) |
createobject( "access.application" ) |
createobject( "msgraph.application" ) |
createobject( "photoshop.application" ) |