Check whether customer is a paying by Credit Card or cash

vb dll

Importing Multiple Placemarks at once

Arrange Place, Latitude and Longitude in an excel.

Then import it to Google Fusion Table

Go to the maps in the third tab

Download the content in kml format.

Open it in google map

Excel Table to One Coloumn

Press Alt+F11 to open the VBE

Press Control+R to view the Project Explorer

Sub MakeOneColumn()

    Dim vaCells As Variant
    Dim vOutput() As Variant
    Dim i As Long, j As Long
    Dim lRow As Long

    If TypeName(Selection) = "Range" Then
        If Selection.Count > 1 Then
            If Selection.Count <= Selection.Parent.Rows.Count Then
                vaCells = Selection.Value

                ReDim vOutput(1 To UBound(vaCells, 1) * UBound(vaCells, 2), 1 To 1)

                For j = LBound(vaCells, 2) To UBound(vaCells, 2)
                    For i = LBound(vaCells, 1) To UBound(vaCells, 1)
                        If Len(vaCells(i, j)) > 0 Then
                            lRow = lRow + 1
                            vOutput(lRow, 1) = vaCells(i, j)
                        End If
                    Next i
                Next j

                Selection.ClearContents
                Selection.Cells(1).Resize(lRow).Value = vOutput
            End If
        End If
    End If

End Sub

Changing Excel Column Data to Row

While I was dealing with some climate excel data (rainfall) it was recorded as follows,
2000 - Jan        10
2000 - Feb        16
2000 - Mar        1
2000 - Apr        14
2000 - May        19
2000 - Jun        12
But I wanted data in below format,

Jan        Feb         Mar        Apr        May         Jun  
10         16           1            14            19           12
So the steps are as follows,
Select the coloumn,
Select Copy
Right Click
Paste Spatial 
Select Value (in Paste) , and Transpose
Click OK

SAS plot graph

ata test1;
input xx yy;
cards;
1 2
3 4
5 6
;
proc plot;
plot xx*yy;
run;

SAS hellow world

data test1;
input xx yy;
cards;
1 2
3 4
5 6
;
proc print;
run;

How to speed up web site laoding time part 1

1. Do  not let browser to reside the images.Spend another 45 second on the image-> edit it from photo shop -> then upload
2. remove white space in the code -> better open the code in server it self and check it.
3. load fewer external objects. Do not embed youtube, slideshare in the home page
4. try to minimize java script conditions in the home page.