Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-22-2021, 08:22 AM
rupd911 rupd911 is offline How to hide/delete slides based on keyword in a separate text file based on AND|OR condition? Windows 10 How to hide/delete slides based on keyword in a separate text file based on AND|OR condition? Office 2016
Novice
How to hide/delete slides based on keyword in a separate text file based on AND|OR condition?
 
Join Date: Feb 2021
Posts: 4
rupd911 is on a distinguished road
Post 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
Reply With Quote
Reply

Tags
automation, notes field, vba code

Thread Tools
Display Modes


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
How to hide/delete slides based on keyword in a separate text file based on AND|OR condition? Macro to delete table rows based on the absence of a single specific keyword JellehFishh Word VBA 2 06-27-2019 08:23 AM
How to hide/delete slides based on keyword in a separate text file based on AND|OR condition? 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

Other Forums: Access Forums

All times are GMT -7. The time now is 07:59 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft