-
Extract data from multiple powerpoint files and paste them to Excel using vba
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.
Tags for this Thread
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules