Get Started with Redwood for Oracle Cloud HCM Begin Now
To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
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
Tagged:
1