Skip to content
Hide Menu
  • Content
  • VBA
  • Excel formula
  • Android
  • Visu+
  • PC Worx
  • e!Cockpit
  • Other
  • Privacy Policy
  • Contact
  • Privacy Policy

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

Visu+

  • Scheduler to create and copy log files
  • Use SQL Server as database

… adding as I find new stuff.

Let’s get social :)

LinkedIn
Share
Facebook
fb-share-icon
Twitter
Tweet
Follow by Email via specificfeeds.com
RSS

Ads

  • © 2023 Online Training
Theme: Skacero by icyNETS