Consulting

Results 1 to 4 of 4

Thread: Deleting some RSS with a specific word in title

  1. #1

    Unhappy 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!

  2. #2
    like wise...

  3. #3
    VBAX Expert JP2112's Avatar
    Joined
    Oct 2008
    Location
    Astoria, NY
    Posts
    590
    Location
    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.
    Regards,
    JP

    Read the FAQ
    Getting free help on the web
    My website
    Please use [vba][/vba] tags when posting code

  4. #4
    VBAX Newbie
    Joined
    Aug 2012
    Posts
    1
    Location
    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
  •