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

vba

WinWriter

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

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 the Word template. WinWriter allows you to maintian a set of work instructions in Excel which can be easily copied, pasted, modified and updated wihtout worrying about the formatting aspects of the final document. The best way to understand the power of WinWriter is to try it out. License The MIT License (MIT) Copyright (c) 2018 Carlos Gamez PermissionRead More →

Excel Custom Formula – GetSheetName()

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

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 a few reporting templates where the main title of each page corresponds to the Worksheet name. In that scenario it is handy to have the name of the Worksheet automatically change in the title of the report. This technique is particularly handy to create preformatted Worksheets which you can then copy/paste and customise, starting with theirRead More →

Excel Application Settings

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

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, you need a centralised place where you can save and retrieve settings form. As you express the business logic of your application in the form of code on the Visual Basic for Applications (VBA) environment, you’ll realise that it’s handy to have a place where you could store and retrieve key-value pairs from any partRead More →

Search

Catalogue

  • Chemical Engineering
    • Avogadro
    • MolView
  • Electrical Engineering
    • Harmonics Visualiser
    • Power Quality Teaching Tool
    • Symmetrical Components
    • Transformers
      • RALE – Transformer Design Software
      • xDGA
  • Mathematics and Calculations
    • SageMath
    • SMath Studio
  • Mechanical Engineering
    • OpendTect
  • Modelling and Design
    • Agros2D
    • FreeCAD
    • SketchUp
    • Tinkercad
    • Z88Aurora
  • Productivity
    • 1Password
    • WinWriter

Topics

analysis algorithms Application Settings artificialintelligence CAD Calculations Chemical Computer Aided Design Data Table dga excel formulas 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 Office Physics power transformers power transformers oil analysis Ribbon rodgers rations Search UI vba VLookup word work instructions xDGA

About Us

  • Our Story
  • Privacy Policy

Copyright © 2021 Engineers Tools