'ping' is not recognized as an internal or external command

Solution for Windows XP:
Right click “My Computer” and click “Properties”. Click the “Advanced” tab up top followed by the “Environment Variables” button at the bottom. In the 2nd list box, scroll down to the 5th or 6th entry “Path”, select it and click “Edit”. Add

%SystemRoot%\system32;%SystemRoot%;

 

 

Excel Move comment into cell as text

Sub ExtractComments()

Dim rComm As Range

Dim Comm

Dim sTmp As String

Set rComm = Cells.SpecialCells(xlCellTypeComments)

For Each Comm In rComm

    '// get Comment text string

    sTmp = Comm.Comment.Text

    '// Move it to cell next

    Comm.Offset(0, 1) = sTmp

    '// Now delete the comment

    Comm.Comment.Delete

Next

Set rComm = Nothing

End Sub