Monday, 6 June 2011

How to enable webAccess in Vmware esx host?

How to enable webAccess in Vmware esx host?

1) Check to see of the WebAccess Service is running

service vmware-webAccess status

2)If webAccess service no started then start it.

service vmware-webAccess start

3) If you want to enable the service permanently.

chkconfig –level 345 vmware-webAccess on

And

esxcfg-firewall -–enableService webAccess

to enable permanently in the vmware firewall

Sunday, 5 June 2011

How to change Excel cell color based on value from another column

Sub ShowRun()           
    Dim i As Integer           
    For i = 1 To 800           
        If Cells(i, 8).Value = "1" Then           
        Cells(i, 3).Interior.ColorIndex = 35           
        ElseIf Cells(i, 8).Value = 2 Then           
        Cells(i, 4).Interior.ColorIndex = 35           
        ElseIf Cells(i, 8).Value = 3 Then           
        Cells(i, 5).Interior.ColorIndex = 35           
        ElseIf Cells(i, 8).Value = 4 Then           
        Cells(i, 6).Interior.ColorIndex = 35           
        Else           
        'Cells(i, 3).Interior.ColorIndex = 16           
        End If           
    Next           
End Sub