Comedy code

Suggest you edit that to make "Gods" lowercase -- "gods" lest brother Van.Geit hafta admonish you... ;-)
 

Excel Facts

How to show all formulas in Excel?
Press Ctrl+` to show all formulas. Press it again to toggle back to numbers. The grave accent is often under the tilde on US keyboards.
Good point!

Don't want to offend Brother Van Geit - these monks can be dangerous (you'll know what I mean if you've read the Da Vinci code ;-) )
 
Yes, but don't tell the Pope. I don't think his Holiness knows about Erik's young'uns... :lol:
 
Monk, Pope, layman are no Biblical terms. Let's respect the pope as human being, but this person has no more authority then any christian. When it comes to adore statues and objects I would only advise: "don't follow that example".

No I am not a monk: just a man who tries to find God and get in contact. Miracles will not bring people to God, but it's a real support for me that I was saved 3 years ago from a surgeon-operation. The fracture was just gone without any human intervention. :-D


OK, guys,
Who will bring us back to the thread ?
 
Who will bring us back to the thread ?
-e.v.g.

Sorry, Erik -- I'm not familiar with that concept :diablo: -- can you use Colo's HTML maker to provide an example of your desired output? :lol:
 
Who will bring us back to the thread ?
Code:
Option Explicit
Sub FixThread()
    Dim Thrd As Thread
    Dim Pst As Post
    Set Thrd = CurrentBoard.Threads("http://www.mrexcel.com/board2/viewtopic.php?t=246668")
    For Each Pst in Thrd.Posts
            If Pst.Author = "Greg Truby" Then Pst.Delete
    Next Pst
End Sub
 
Great code Aaron! I notice that there's new posts by the Trubinator all the time - so maybe you should make that code recursive and across all threads?

Code:
Option Explicit
Sub FixThreads()
    Dim Thrd As Thread, Dim RemTrube As Date
    Dim Pst As Post
    RemTrube = Now + TimeValue("00:15:00")
    Set Thrd = CurrentBoard.Threads
    For Each Pst in Thrd.Posts
            If Pst.Author = "Greg Truby" Then Pst.Delete
    Next Pst
    Application.OnTime RemTrube, "FixThread"
End Sub

If it runs every 15 minutes, that'll limit Truby to only a potential 75 or so misdirecting posts :nya:


:lol:
 

Forum statistics

Threads
1,222,723
Messages
6,167,853
Members
452,149
Latest member
gatje

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top