|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How to hide/delete slides based on keyword in a separate text file based on AND|OR condition?
Hello Team,
Can someone help me with this problem statement? Problem Statement: I have a text file where the first line is "OR"/"AND". The subsequent lines are some keywords. I also have a ppt where each slide has a note with a bunch of comma-separated keywords. The idea is to develop an automation script that will read the first line of the text file and: [if the first line is "OR"]: read all the keywords in the text file and hide/delete all the slides in the ppt except for the ones where "ANY" of the keywords in the notes field match the keywords in the text file. [if the first line is "AND"]: read all the keywords in the text file and hide/delete all the slides in the ppt except for the ones where "ALL" of the keywords in the notes field match the keywords in the text field. if there are extra keywords in the notes field, that is okay. With thanks and best regards, RUPD |
Tags |
automation, notes field, vba code |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Show/Hide text based on dropdown value | AOSMITH | Word VBA | 2 | 11-19-2019 02:19 PM |
Macro to delete table rows based on the absence of a single specific keyword | JellehFishh | Word VBA | 2 | 06-27-2019 08:23 AM |
Hide/Show text based upon check box status | nathan.gray@emerson.com | Word VBA | 5 | 12-08-2017 01:08 PM |
Automatically delete row based on keyword-VBA | yoyo4 | Excel Programming | 4 | 12-06-2017 06:10 AM |
Automatically Delete Slides based on current time | Pacman52 | PowerPoint | 2 | 07-16-2015 05:30 AM |