Showing posts with label Control system documentation tips. Show all posts
Showing posts with label Control system documentation tips. Show all posts

Thursday, February 9, 2017

Useful Excel VBA code to create documentation of Control Systems valuable for migrations. Reads multiple text or source code and organizes the info in Excel

Read txt files or source code in Excel, organize the information, this is a excellent tool when you want to migrate control systems.

In the next example, I am using a backup file generated by the control system and extracting and organizing the information in Excel.

To read this article in Spanish, please visit: www.guiaautomatizacionindustrial.blogspot.com

How to create easily an Excel list of the files contained in a folder

Sometimes create a list of files contained in a folder could be annoying. If the number of files is small, not a big deal, but when the amount of file gets bigger, this task could be boring!!
Because of this, I will show you how to get a list of files quickly! This help me a lot when I was trying to make a list of the control graphics contained in a folder. Follow the next steps:

To read this article in Spanish, please visit: www.guiaautomatizacionindustrial.blogspot.com