Archive

Author Archive

Tired of switching settings between home and office network

December 8, 2009 Leave a comment
Most people with notebooks from work that they unfortunately have to use at home as well to do some ‘quality’ work it is a slight nuisance having to switch network settings every time they switch networks between home and work and/or any other location.

In my case, I have separate settings for the 3 locations where i use my notebook, at work I have to specify a proxy server to be able to access the internet, at home (as in ‘back home’) i have to specify a DNS for my connection to work and at home ‘here’ I have to disable all configurations (specifying ‘automatic’ everywhere) to be able to breathe.
As the famous saying goes ‘Laziness is the mother of invention..’ and also because most systems (specially mine) get so bloated with time with software evolving at a much faster pace than hardware that it takes ages (literally over 20 minutes) for them to become responsive after a reboot, that it is a nightmare having to wait for everything to ‘pretend’ to start working before you realize that half the widgets/gadgets on the screen haven’t refreshed and your msgr not signed in because you need to modify the connection settings for things to start working.
So I started out on my quest to try and locate a software or method to be able to associate proxy servers with specific connections (as in the case of the good old iPhone .. and I believe other mobile platforms). Unfortunately I wasnt able to locate anything of the sort
but what I found a worthwhile alternative in the form of a handy utility. Now I dont have to remember the various settings and DNS configurations when i move between locations.
although, if this utility runs at startup, it definitely is going to add to the boot time and bloatware, and again I need to manually select which connection profile to use, but it still beats having to open up IE or chrome and navigate to the connection settings just to make a modification irrespective whether the task at hand requires a browser or not.
Hence, I would like to share with you, to save you 5 minutes of pain at least twice a day the amazing Free IP Switcher 🙂

microsoft Office 2010 BETA MAK

November 18, 2009 Leave a comment

 

Quote

7XD2X-JWJ94-BCHBW-W9WXP-J2WPT

Categories: Uncategorized

reference from

August 10, 2009 Leave a comment

 

Quote

GMail Midlet client – WinMo @ MoDaCo
1. Install IBM’s virtual JVM : http://forum.xda-developers.com/showthread.php?t=279600 (can use either version depending on yer preference where you want to install it)2. The midlet manager requires the location of .jad and .jar files, enter this url : http://gmail.com/app/v1.0.0/en/gm-Generic-Advanced_MIDP2.jad (in case it says during download .jar file was not found try again the link must’ve dropped)3. In case you’re wondering where can you get the files for google maps : http://www.google.com/gmm/apps/v1.3.1/L1/g…ed_MIDP2_L1.jad

Categories: Uncategorized

How to Write ISO Files to CD

Probably a tool that should have been included in stock windows XP – more over Microsoft fails to address this need even in 3 SP’s since the release of Windows XP.

Thanks to Alex Feinman, you can now use default Windows drivers to burn ISO images to CD (DVD not supported) from within Windows XP.

How to Write ISO Files to CD

Categories: Uncategorized

Add Preview Handlers for Outlook 2007

A very useful post with Preview Handler download (including ZIP and HTML preview).

Add Preview Handlers for Outlook 2007

Categories: Uncategorized

How do I… Use BootVis to improve XP boot performance? | Microsoft Windows | TechRepublic.com

December 27, 2008 Leave a comment
Categories: Uncategorized

How-To: Connect HUAWEI E220/E270 Modem with Mac OS X 10.5 (Leopard) | Tech Thought

December 18, 2008 Leave a comment

still trying to get it to work though..

I think my mac installation has an issue, does not display any additional network hardware even after driver installation.

How-To: Connect HUAWEI E220/E270 Modem with Mac OS X 10.5 (Leopard) | Tech Thought

Categories: Uncategorized

Getting GMail Mobile/Opera Mini (or any java midlets) working on Nokia 6230i

December 13, 2008 1 comment

I have been trying to get GMail applet/midlet and Opera mini working on my old Nokia 6230i cellphone since I lost (unfortunate incident) my Windows Mobile PDA a couple of months back. After installing Gmail (and Mail by Google – which I wouldn’t be using anymore as I opted to move back to an MS Exchange account for work emails – having lost the ability to check emails on the phone) and Opera mini on the phone I struggled for days trying to get the irritating message regarding ‘This program requires a data connection. etc. etc.’ even though my phone browser could access the internet just fine.

after getting no where with either the Google FAQs or the Opera Mini FAQ’s I had given up hope and settled for waiting another couple of months till I was able to get a new WMobile PDA before venturing back into a world of internet connectivity on the go.

Until recently, for some reason I needed to get a decent web browser on the phone again and decided to give it another shot.

After a couple of hours of not getting anywhere I realized it had something to do with the midlet/java settings rather than application specific settings.
this led to a short search on the nokia support forums for specifically midlet issues related to the 6230i model and the following result turned up to be the solution for all the midlet/Java connectivity woes on the 6230i.

Access point configuration for Java/Midlets on Nokia 6230i phone

Excel & VBa: find last row, column, cell in an Excel (work)sheet

November 26, 2008 Leave a comment

Please visit the following site for the original Article.

http://www.nijbo.net/index.php?option=com_content&task=view&id=14&Itemid=32&mosmsg=Thanks+for+your+vote!

I found it extremely useful, hence, decided to copy it here for future reference.

 

User Rating: / 7 
PoorBest 

The following page contains some usefull (general) vba code that can be used to find the last row, columnand/or cell in an Excel (work)sheet.
Find the last used cell, before a blank in a Column:
Sub LastCellBeforeBlankInColumn()
  Range("A1").End(xldown).Select
End Sub 

Find the very last used cell in a Column:
Sub LastCellInColumn()
  Range("A65536").End(xlup).Select
End Sub

 
Find the very last used cell in a Column: 
Sub LastCellInColumn()
  Range("A65536").End(xlup).Select
End Sub

Find the last cell, before a blank in a Row: 
Sub LastCellBeforeBlankInRow()
  Range("A1").End(xlToRight).Select
End Sub

Find the very last used cell in a Row: 
Sub LastCellInRow()
  Range("IV1").End(xlToLeft).Select
End Sub

Find the very last used cell on a Worksheet: 
Sub Demo()
  Cells.Find(What:="*", After:=[A1], SearchDirection:=xlPrevious).Select
End Sub
 
Find the last used Row on a Worksheet:
Sub FindLastRow()
  Dim LastRow As Long

  If WorksheetFunction.CountA(Cells) > 0 Then
    ‘Search for any entry, by searching backwards by Rows.
    LastRow = Cells.Find(What:="*", After:=[A1], _
                         SearchOrder:=xlByRows, _
                         SearchDirection:=xlPrevious).Row
    MsgBox LastRow
  End If
End Sub

Find the last used Column on a Worksheet:
Sub FindLastColumn()
  Dim LastColumn As Integer
  If WorksheetFunction.CountA(Cells) > 0 Then
    ‘Search for any entry, by searching backwards by Columns.
    LastColumn = Cells.Find(What:="*", After:=[A1], _
                            SearchOrder:=xlByColumns, _
                            SearchDirection:=xlPrevious).Column
    MsgBox LastColumn
  End If
End Sub

 
Find the last used Cell on a Worksheet:
Private Sub FindLastCell()
  Dim LastColumn As Integer
  Dim LastRow As Long
  Dim LastCell As Range
  If WorksheetFunction.CountA(Cells) > 0 Then
    ‘Search for any entry, by searching backwards by Rows.
    LastRow = Cells.Find(What:="*", After:=[A1], _
                         SearchOrder:=xlByRows, _
                         SearchDirection:=xlPrevious).Row
    ‘Search for any entry, by searching backwards by Columns.
    LastColumn = Cells.Find(What:="*", After:=[A1], _
                            SearchOrder:=xlByColumns, _
                            SearchDirection:=xlPrevious).Column
    MsgBox Cells(LastRow, LastColumn).Address
  End If
End Sub 
 
Add a row at each change in a column.
Assume you have a long list of data and you want to insert a row at each change. While you could use a simple Loop this method is much faster. The Data must be sorted!
 
Option Explicit

Private Sub InsertRowAtEachChange()
  Dim objRange As Excel.Range

  ”’ On error goto the error handler defined in the lower part of this function.
  On Error GoTo ErrHandler

  ”’ Ensure an entire Column is selected
  If Selection.Cells.Count <> 65536 Then
    Call MsgBox("You must select an entire column", vbCritical)
    End
  End If
  
  ”’Set a range variable to all data in selected column
  Set objRange = Range(Selection.Cells(2, 1), Selection.Cells(65536, 1).End(xlUp))

  ”’ Add a column for formulas
  With objRange
    .EntireColumn.Insert
    .Offset(0, -1).FormulaR1C1 = "=IF(AND(NOT(ISNA(R[-1]C))," & _
                                 "R[-1]C[1]<>RC[1]),0,"""")"
    ”’ Convert to values
    .Offset(0, -1) = .Offset(0, -1).Value
    ”’ Set variable to 0
    Set objRange = .Offset(0, -1).SpecialCells(xlCellTypeConstants, xlNumbers)
  End With
   
  ”’ Add a row at each 0
  If WorksheetFunction.CountIf(objRange, 0) > 0 Then
    Call objRange.EntireRow.Insert
  End If
  
  ”’ Reset variable for next formulas
  Set objRange = Range(Selection.Cells(2, 1), Selection.Cells(65536, 1).End(xlUp))
  
  ”’ Add the formula to add 0
  objRange.FormulaR1C1 = "=IF(OR(RC[1]="""",R[-1]C[1]=""""),""""," & _
                         "IF(RC[1]<>R[-1]C[1],0))"
  ”’ Convert to values
  objRange = objRange.Value
  
  ”’ Set variable to 0 cells if any
  If WorksheetFunction.CountIf(objRange, 0) > 0 Then
    Set objRange = objRange.SpecialCells(xlCellTypeConstants, xlNumbers)
    ”’ Add a row at each 0
    objRange.EntireRow.Insert
  End If
  
  ”’ Delete added Column
  Call objRange.Columns(1).EntireColumn.Delete

  ”’ Remove an instance
  Set objRange = Nothing

  ”’ Exit the Sub
  Exit Sub
    
”’ Define the subfunction for errorhandling.
ErrHandler:
  ”’ Error.
  ”’Call gobjLogFile.Error("ThisWorkbook, function : InsertRowAtEachChange", _
                         "Description goes here", Err.Number, Err.Description)
  
  ”’ Resume anyway.

  Resume Next

End Sub 

 

Categories: Uncategorized

Open Source Matter: VLC Screencast

August 16, 2008 1 comment
Categories: Uncategorized