Tag: vba
Extracting data with Excel VBA from SVMON output
Back to the main data prep VBA page This is a small Excel VBA script I wrote to pull the SVMON memory statistics for a specific PID that contains concatenated SVMON output. I’ve had to modify th... Read More
Extracting data with Excel VBA from DB2diag logs
Back to the main data prep VBA page Here’s a relatively obscure Excel VBA script that you would likely never use, but it is helpful if you care about IBM DB2 buffer cache sizes over time that ca... Read More
Extracting data with Excel VBA from DB2 snapshots
Back to the main data prep VBA page I use this script to compile data from multiple DB2 snapshots into a single time series table that can be used to generate time series plots for use in enterprise w... Read More
Extracting data with Excel VBA from NMON output
Back to the main data prep VBA page This is a script I use for extracting data of interest from NMON output. Often I need t0 extract data from a variety of tools a customer is comfortable using, an... Read More
Extracting data with Excel VBA from IOSTAT output
Back to the main data prep VBA page This is a sample script that I used in Excel VBA to extract data from IOSTAT output trapped at a regular interval (typically 15 seconds) to create a single row time... Read More
Extracting data with Excel VBA from Oracle AWR reports
Back to the main data prep VBA page This is an old script I created that imports HTML based reports into Excel, searches for the target headers in the file, then pulls key data I specified for the OLT... Read More