-
Deleting some RSS with a specific word in title
Hello all, and congratulations for this excellent forum!
I'm totally new to VBA... although I have worked with SH, TCL, C, etc. scripts.
I'm having problems building a script that should be executed when a new RSS arrives to its respective folder. I have an incoming RSS feed which inform me of some events. There are 2 kinds of feeds: the ones that "set" the event (in form of: SET event nș x) and the ones who "clear" the event (in form of: CLEAR event nș x). If the "x" in the event title are the same in both, "set" and "clear" RSS, I need to delete them.
What I have done so far, is to read the title of all the RSS in a particular RSS folder.
[VBA]
Sub test()
Dim item As Object
Dim flRss As Folder
Dim sub_folder As MAPIFolder
Set flRss = Application.GetNamespace("MAPI").GetDefaultFolder(olFolderRssFeeds)
Set sub_folder = flRss.Folders("ALT1040")
For Each item In sub_folder.Items
Debug.Print item.Subject
Next item
End Sub
[/VBA]
The logic will be: if there is a "clear" word, search for the same rss title with a "set" word, and then, delete both.
I know about logic, but don't know about VBA.
Can you guys help me with this?
Thanks!
-
-
Check out the code posted here:
http://www.vbaexpress.com/forum/showthread.php?t=43136
You simply need to point it to the RSS folder.
-
I just need these, now I find these things, thank you for sharing. Let me know these things.
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