I am working on the excel recorder to extract the column header from an excel file. For this case I am using the Power query editor to do lot of function like
Transpose table, extract text before delimiter, Replace values, Merge column. After completing all the formatting, I click on the Close and load option.
Then I stop my excel recorder. But I am getting Test run failed and in the VB script I am getting Complile Error. My Macros in the excel are enabled
Can you please tell me whether excel recorder support Power Query Editor. if so, Please let me know do we have any prerequisite?