Skip to content
Hide Menu
Content
VBA
Excel formula
Android
Visu+
PC Worx
e!Cockpit
Other
Privacy Policy
Contact
Privacy Policy
Search for:
Online Training
Menu
VBA
Add Styles with VBA
Array in array
Autofilter or Unfilter data
Check if any hidden rows or columns
Check if a sheet exists
Connect to IBM DB2
Convert a cross-tab to a data table
Copy a list of files
Count within groups – macro
Create links from sheet names
Create custom menu based on a text list
CSV to recordset
Extract URL from shape
Extract URL from text
Find a suitable delimiter
Get file name or path
Get Program Files path
Get the address parts from a selected range
Get the last row or column
Get the windows username
List all Comments
List files properties from a folder
List files or folders using .bat file
List sheets’ properties
Loop through filtered cells
Make sheets visible and remove passwords
Merge files and remap columns using SQL
Open file For
Pick a file or a folder using a dialog
Prepare report files for SQL upload
Range to recordset
Read/ write/ delete registry
Read a config file to a Dictionary
Select/fill visible cells
Toggle Excel functionalities to speed up a macro
Unzip all archives from a folder
Use Enum for dropdown function arguments
Excel formula
Convert report into data table
Convert YYYYMMDD to date
Count within groups – formula
Filter bold text
Football bet template
Job satisfaction check
Romanian Whist score keeper
Subtotal on filtered data
Team Holiday Planner
Android
Uninstall system apps
Visu+
Use SQL Server as database
Scheduler to create and copy log files
PC Worx
Connect to a MS SQL Server database
Toggle PC Worx SRT service
e!Cockpit
Connect PLC to MS SQL from e!Cockpit
Other
Create .exe from .bat or .vbs with IExpress
Diamond painting in Excel
Settings to Connect a PLC to SQL Server
Task Scheduler to move files
Technical documentation vs Training materials
Use Card Storage app to inventory items
PC Worx
Connect to a MS SQL Server database
Toggle PC Worx SRT service
… adding as I find new stuff.
© 2025
Online Training
Theme:
Skacero
by
icyNETS