Categories
- CommandBar
- Display
- Printing
- Forms
- Graphics and Shapes
- Math
- Text
- Controlling
- Workbooks and Worksheets
- Ranges and cells
- Date and time
- Tools and Applications
- Internet
- Databases
- Other
- Project Euler
|
Recent Additions- Databases: Retrieving data from an Oracle database to Excel using Oracle Objects for Office (OO4O)
Oracle databases are widely used. To improve connectivity with coding environments like VB and VBA they created Oracle Objects for Office (OO4O). There are advantages using OO4O rather than ADO (with and OLEDB driver) or ODBC. First and foremost its simply fast, if coded properly. Secondly it is very easy to code. Once you get to know the object model of OO4O you'll find that's its real easy to navigate between records and to create routines to work with an Oracle database. The object model is very complete. - Project Euler: Project Euler - Problem #4
- Project Euler: Project Euler - Problem #3
- Internet: Ping a computer in VBA using WMI
Windows Management Instrumentation (WMI) provides a uniform interface for any local or remote applications or scripts that obtain management data from a computer system, a network, or an enterprise. Information such as a computer name, logged in user and even process data can be easily retrieved using any script language that supports ActiveX objects. - Internet: Ping a computer in VBA
Windows Scripting is a very powerful tool to work with a network. You can do many things with it. This example demonstrates the usage of the Shell and FileSystem object to do a ping to a server on the internet.
|
