VBA to Parse HDL .dat files into Excel

Summary

This VBA Code allows you to parse the .dat file into Excel as text and puts each meta data section on individual worksheet tabs for easier manipulation and review of the file.

Content

This VBA will allow easier manipulation of the HDL file in Excel without manually importing the file and parsing it by hand.

Sub FindMetaData()

' FindMetaData Macro
'The purpose of this code is to split out HDL files into seperate worksheets automatically after they are manually parsed
'declare variable types
Dim newWB As Workbook, currentWB As Workbook
Dim newS As Worksheet, currentS As Worksheet
Dim CutRange As Range