Skip to content
Engineers Tools
Engineers Tools
Primary Navigation Menu
Menu
  • Articles
    • myActivo DevBlog
  • Software Tools
    • Chemical Engineering
    • Electrical Engineering
    • Mathematics and Calculations
    • Mechanical Engineering
    • Modelling and Design
    • Productivity
  • Books
    • Electrical Engineering
  • Contact Us

vba

WinWriter

WinWriter is an Excel template that can be used to automatically generate Work Instructions as Word documents. This provides a great separation of concerns by keeping the content of the documents in an easy to manage table-like format while the look and feel of the Work Instruction is controlled via theRead More →

2018-01-28
In Productivity
Tagged document automation, document generation, excel, excel automation, vba, word, work instructions

Excel Custom Formula – GetSheetName()

Short Description Create a simple Excel function that returns the name of the Worksheet where that cell is. Ingredients Microsoft Excel The Need When working with Excel Workbooks that contain multiple Worksheets, you might need to get the name of the each Worksheet in formulas. For example, I have aRead More →

2016-02-20
In Software Engineering
Tagged Custom Formula, excel, Formula, UDF, User Defined Function, vba

Excel Application Settings

Short Description Create an Excel Add-in that allows you to add Application Settings functionality on any Workbook. Store and retrieve setting names and values on a centralised location and accessible anywhere from your VBA modules and classes. Ingredients Microsoft Excel The Need Sometimes when you are creating an Excel tool or application,Read More →

2016-01-25
In Software Engineering
Tagged Application Settings, vba

Topics

analysis algorithms Application Settings Artificial Intelligence Asset Management CAD Calculations Chemical Computer Aided Design Data Table dga excel formulas Digital Asset Management dissolved gas analysis document automation document generation Drawing duval pentagons duval triangles Education Electrical Engineering excel excel add-ins excel automation FEA FEM Finite Element Analysis Finite Element Modelling HLookup how to iec 60599 ieee c57.104 machinelearning Mathematics Modelling Molecules Physics power transformers power transformers oil analysis rodgers rations Search Software Development vba VLookup word work instructions xDGA

About Us

  • Our Story
  • Privacy Policy

Copyright © 2023 Engineers Tools