Pre-bind and post-bind in VBA Development

tag: http OS Io uses the strong ar file data CTI

Any object that can be created using Createobject can obtain its method, attribute, enumeration, and event list in the Object Browser after referencing the corresponding library file, such as shell. the application object is located in the shell32 library, find and select "micorsoft shell controls and automation" under "tools-Reference", and then you can see it in the Object Browser, in this way, when creating a new shell object, you can use dim sh as new shell32.shell instead of creatojbect. In this way, the method for creating an object is called pre-binding,The running speed is faster than the post-binding method, and the intelligent sensing list can be added after the object during programming, making development easier.
Common examples include:
"Interneteplorer. application" (Microsoft Internet controls) is used to operate IE Windows.
"VBScript. Regexp" (Microsoft VBScript Regular Expressions 5.5) is used for Fuzzy verification, search, and replacement of strings.
"Scripting. FileSystemObject" (Microsoft scripting runtime) 'is used to operate files and directories.
"ADODB. Connection", "ADODB. Stream" (Microsoft ActiveX Data Objects 2.8 Library) 'is used for database connection and data flow operations.
"Microsoft. XMLHTTP" (Microsoft XML, version 2.0) 'is generally used to download files from the Internet.
"Wscript. Shell" (Windows Script Host Object Model) 'can be used to operate the registry, manage processes, and create shortcuts. Some functions overlap with FileSystemObject.

Pre-bind and post-bind in VBA Development