I have many powerpoint files (.pptx) in a folder. Each file has only one slide with pictures, shapes and textboxes. All ppt files have same names of text boxes. I want to transfer data from each ppt to excel.

For each ppt, I want the data of TextBox 6 in column A, TextBox 38 in column B, filename of each ppt in column C, DateCreated of each ppt in column D.

Please somebody help.