Steuben Trust Company – Apply for loans, banking, and financial services at www.steubentrust.com Steuben Trust Company is a well-known banking services provider in Western, Southern, and New York Tiers. It has been in service since 1902. Steuben Trust Company provides banking and financial services for businesses and individuals (personal). Apart from that, it also deals […]
Calling the Excel VBA SpecialCells method on a single cell will return special cells of the specified type for the entire worksheet. The function below will return a range of specified special cells for a worksheet, range or a single cell. This is the workbook I used to test with.
Measuring code execution time to the millisecond (or microsecond) #If Win64 Then Private Declare PtrSafe Function getFrequency Lib “kernel32” Alias “QueryPerformanceFrequency” (cyFrequency As Currency) As Long Private Declare PtrSafe Function getTickCount Lib “kernel32” Alias “QueryPerformanceCounter” (cyTickCount As Currency) As Long #Else Private Declare Function getFrequency Lib “kernel32” Alias “QueryPerformanceFrequency” (cyFrequency As Currency) As Long Private […]
This is the start of a VBA file operations class. Currently, it can be used to detect if a file exists, and return file times – date last accessed, date created, date last modified. I will be extending the class over time. Add a comment if there is something in particular you would like to see […]
For testing, I needed a quick way to switch Excel Trust Center settings between restrictive and permissive. Using Process Monitor and these settings, I was able to observe the registry keys and settings Excel’s Trust Center uses to store values. Using these key/values, I created a VBScript file to automate switching between restrictive and more permissive Trust Center settings.The script […]