Categorieën
- 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
|
Recentelijke Toevoegingen- Tools and Applications: Grep & Replace - clean text files from unwanted text
Grep & Replace searches for a certain string (optional begin and end substrings) in text files and optionally replaces it with another string. - 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.
|
