RSS

Category Archives: Tools

Backup Your Tweets in Excel

I had written many small haikus on Twitter and I wanted to save them for later.

To do this, you should first save your tweets as an XML file.
Go to http://twitter.com/statuses/user_timeline/userid.xml?count=x

In the above link, replace “userid” with your user name and “x” with the number of tweets you want to download. (You can view your total number of updates on your twitter page.)

When the page opens, click Save As in your browser and save the XML file to your computer.

Open MS-Excel(2007) and click Data -> From Other Sources -> From XML Data Import

In other versions of MS-Excel, you would click Data -> XML -> Import

Browse your computer and select the Twitter XML file you downloaded.

Ta daaaa!!!!!!!!

You have all your tweets in a neat Excel sheet. Enjoy! 🙂

 
1 Comment

Posted by on July 29, 2011 in Tools

 

Macro to Extract Comments from a PPT to a Text File

Use the macro below to extract all the comments in a PPT file to a text file. You can then print the text file.

When you run this macro, it opens an Output File dialog box asking for a path to store the text. Remember to enter a name for the file when you specify the path in the ‘Output file’ dialog. Example: C:\Documents and Settings\User1\Desktop\comments.txt

Sub ExportComments()

    Dim oSl As Slide
    Dim oSlides As Slides
    Dim oCom As Comment
    Dim sText As String
    Dim sFilename As String

    Set oSlides = ActivePresentation.Slides
    For Each oSl In oSlides
    sText = sText & "Slide: " & oSl.SlideIndex & vbCrLf
    sText = sText & "======================================" & vbCrLf
        For Each oCom In oSl.Comments

            sText = sText & oCom.Author & vbCrLf
            sText = sText & oCom.DateTime & vbCrLf
            sText = sText & oCom.Text & vbCrLf
            sText = sText & "--------------" & vbCrLf

        Next oCom
    Next oSl

    sFilename = InputBox("Full path to output file:", "Output file")
    If Len(sFilename) > 0 Then
        WriteStringToFile sFilename, sText
        SendFileToNotePad sFilename
    End If

End Sub

Sub WriteStringToFile(pFileName As String, pString As String)
' This writes the text out to a file

    Dim intFileNum As Integer

    intFileNum = FreeFile
    Open pFileName For Output As intFileNum
    Print #intFileNum, pString
    Close intFileNum

End Sub

Sub SendFileToNotePad(pFileName As String)
' This opens the file in notepad

    Dim lngReturn As Long
    lngReturn = Shell("NOTEPAD.EXE " & pFileName, vbNormalFocus)

End Sub

Macro courtesy: pptfaq.com

 
1 Comment

Posted by on July 8, 2011 in MS Office, Tools, Utilities

 

MS-Word Building Blocks

My job involves using 30 different types of tables repeatedly across a document. I usually have a source document from which I copy each table template and paste it into the document I’m working on. Recently, I was trying to find a better way to do this. I thought I should record a macro for each table and save it as a button. However, Word 2007 allows for very little customization of the ribbon (without some complicated VB scripting etc.) and that’s when I stumbled upon Building Blocks.

If you have objects (tables, drawings, paragraphs, pictures) that you need to repeatedly paste into a document, you can also use the following method. I have demonstrated with a table as an example:

1. Open a new word document.

2. Copy and paste the template table for ST1 into the new document.

3. Select the entire table (or object).

null

4. Press ALT+F3

5. A box named “Create New Building Block” will open up. Select the options shown in the image below and click Ok.

null

Note: You can also add the table to any other category which you think might be easier for you to access.

6. Repeat the steps for all the tables or objects you use frequently.

7. To insert the table or object, go to Insert -> Table -> Quick Tables and select on the table you want to insert.
null

8. Voila! 🙂

 
1 Comment

Posted by on February 28, 2011 in Tools, Tricks

 

Tags: , ,

Macro to Highlight Track Changes in Word

Note: This macro highlights only the insertions in your track changes. It does not highlight the deletions.

Often, we need to highlight the changes in our document after making the corrections suggested by a reviewer. I came across this interesting macro that made my job easy.

To change the highlight color, find the word WdYellow in the code above and change it to WdTurquoise, WdBrightGreen or other highlight color names.

Macro Courtesy: p2p.wrox.com

 
6 Comments

Posted by on February 23, 2011 in Tools, Tricks