RSS

Monthly Archives: July 2011

How to Download a Page from Google Books?

How to Download a Page from Google Books?

I will tell you upfront that you’ll need the Google Chrome browser to use this method.

1. Open the Google book in your Google Chrome browser and go to the page you wish to download.

2. Right-click on the page and select Inspect Element

3. Under Inspect Element, go to Resources and select Images.

4. Browse all the images and find the image of the page you wish to download. Sometimes it will be available in more than one size. In such cases, select the image with the best size.

5. Double-click the image name to open the image in a new tab. Right-click the image and select Save Image As.

6. Save the file to your local machine and enjoy!

Enjoy! 🙂

Advertisements
 
20 Comments

Posted by on July 29, 2011 in Tricks

 

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