16 Mar 2013 http://stackoverflow.com/questions/1907196/how-do-i-check-if-its-monday-to-friday-and-the-time-is-between-10-am-to-3-pm >>> import datetime >>> d = datetime . datetime . now () # => datetime.datetime(2009, 12, 15, 13, 50, 35, 833175) # check if weekday is 1..5 >>> d . isoweekday in range ( 1 , 6 ) True # check if hour is 10..15 >>> d . hour in range ( 10 , 15 ) True # check if minute is 30 >>> d . minute == 30 False 05 Mar 2013 This code from StackOverflow helped me find whether a workbook was open with its name. Here's the link to the thread: Link Function BookOpen(strBookName As String) As Boolean
Dim oBk As Workbook
On Error Resume Next
Set oBk = Workbooks(strBookName)
On Error GoTo 0
If oBk Is Nothing Then
BookOpen = False
Else
BookOpen = True
End If
End Function
Sub testbook()
Dim strBookName As String
strBookName = "myWork.xls"
If BookOpen(strBookName) Then
MsgBox strBookName & " is open", vbOKOnly + vbInformation
Else
MsgBox strBookName & " is NOT open", vbOKOnly + vbExclamation
End If
End Sub
27 Feb 2013 These are my notes for installing Eastein's announce. It's a IRC bot that will receive a message and do text to speech on the message: https://github.com/eastein/announce Installation: Download announce and extract it to it's own folder.apt-get install python-irclib apt-get install python-pip sudo apt-get install python-dev apt-get install festival festlex-cmu festlex-poslex festlex-oald libestools1.2 unzip apt-get install speech-tools pip install pyzmq --install-option="--zmq=bundled"or (if you have easy_install installed): download mediorc and move mediorc into directory easy_install dnspython apt-get install mplayer apt-get install sox Fix permissions:
Running The Program: Run process in background by starting a screen (first navigate to the Announce folder): (start a new screen) python announced "tcp://*:4900" (detach from screen) (start a new screen) python announcebot "chat.freenode.net" "voicebot" "#yourircchannel" "tcp://0:4901" (detack from screen) Starting the program using mp3 files in the JSON file (as always, start in the folder which has Announce):
wget http://fake.com/fake/eye_tiger.mp3 (use a real URL with an mp3 file) nano default.json enter into the json file: [ ["eye of the tiger", "eye_tiger.mp3"] ] ctrl+x and save (start a new screen) python announced "tcp://0:4900" default.json (detach from screen) (start a new screen) python announcebot "chat.freenode.net" "voicebot" "#yourircchannel" "tcp://0:4900" (detach from screen) now "!say eye of the tiger" in the IRC channel will trigger the mp3 Troubleshooting: Ensure your Raspberry Pi audio is working: http://jeffskinnerbox.wordpress.com/2012/11/15/getting-audio-out-working-on-the-raspberry-pi/ Testing Festival (create a text file named mytext.txt with some words first):
echo "This is a test." | festival --tts
echo "this is a test" > mytext.txt
text2wave -o myaudio.wav mytext.txt
adjust the volume: