Friday, December 19, 2008

Online Bank to Bank Transfer - NEFT

FAQ on EFT System
1. What is RBI-EFT System?

RBI EFT is a Scheme introduced by Reserve Bank of India (RBI) to help banks offering their customers money transfer service from account to account of any bank branch to any other bank branch in places where EFT services are offered.

2. At how many centres and bank branches is the EFT facility available?

The EFT system presently covers all the branches of the 27 public sector banks and 55 scheduled commercial banks at the 15 centres (viz., Ahmedabad, Bangalore,Bhubneshwar, Kolkata, Chandigarh, Chennai, Guwahati, Hyderabad, Jaipur, Kanpur, Mumbai, Nagpur, New Delhi, Patna and Thiruvananthpuram). Funds transfer is possible from any branch of these banks at these centres to other branch of any bank at these centres both inter-city and intra-city.

3. What is the funds availability schedule for the beneficiary?

If the remitting bank transmits the funds transfer message to RBI so as to hit the first

settlement at 12 noon, the receiving bank’s account is credited by RBI at the
destination centre and beneficiary gets the credit on Day 1 itself. If the same is
included in subsequent settlements i.e., for 2 pm and 4 pm, the beneficiary gets
credit on Day 2.
4. How does the RBI EFT system operate?
Step-1: The remitter fills in the EFT Application form giving the particulars of the
beneficiary (city, bank, branch, beneficiary’s name, account type and account
number) and authorises the branch to remit a specified amount to the beneficiary by
raising a debit to the remitter’s account.
Step-2: The remitting branch prepares a schedule and sends the duplicate of the
EFT application form to its Service branch for EFT data preparation. If the branch is
equipped with a computer system, data preparation can be done at the branch level
in the specified format.
Step-3: The Service branch prepares the EFT data file by using a software package
supplied by RBI and transmits the same to the local RBI (National Clearing Cell) to
be included for the settlement of 12 noon, 2 pm and 4 pm.
Step-4: The RBI at the remitting centre consolidates the files received from all
banks, sorts the transactions city-wise and prepares vouchers for debiting the
remitting banks on Day-1 itself. City-wise files are transmitted to the RBI offices at
the respective destination centres.
Step-5: RBI at the destination centre receives the files from the originating centres,
consolidates them and sorts them bank-wise. Thereafter, bank-wise remittance data
files are transmitted to banks on Day 1 itself. Bank-wise vouchers are prepared for
crediting the receiving banks’ accounts the same day or next day.
Step-6: On Day 1/2 morning the receiving banks at the destination centres process
the remittance files transmitted by RBI and forward credit reports to the destination
branches for crediting the beneficiaries’ accounts.

List of Upscale Hotel in the World

Some of the List of Upscale Hotel of the world are:

  1. Adams Mark
  2. AmeriSuites
  3. Ayres Hotels & Suites
  4. Club Med
  5. Club Quarters
  6. Coast Hotels & Resorts
  7. Courtyard by Marriott
  8. Crowne Plaza
  9. Four Points
  10. Hawthorn Suites
  11. Hilton Garden Inn
  12. Homewood Suites
  13. Novotel
  14. Outrigger Hotels & Resorts
  15. Radisson
  16. Residence Inn by Marriott
  17. ResortQuest Hawaii
  18. Sierra Suites
  19. SpringHill Suites
  20. Staybridge
  21. Summerfield Suites by Wyndham
  22. Woodfield Suites
  23. Woodfin Suite Hotels
  24. Wyndham Hotels & Resorts

Quicker Way to Launch Program

Windows Vista assigns shortcuts to all the items in your Quick Launch toolbar, on its own, depending on the icons� positions in the sequence. So if you want to open the program whose icon is the fourth in your Quick Launch bar, just press the Windows key + 4.

Resize Icon of Desktop on fly in XP Vista

Resize icons on the fly :

If you want to resize the icons quickly in Windows Vista Explorer, press and hold the Ctrl key, and scroll up or down with the mouse wheel

Backingup Microsoft Outlook Autocomplete List

Backing up the Microsoft Outlook auto complete list is indeed possible and easier than you think.

From a users standpoint, there are very few things more important than the auto complete ability of Microsoft Outlook. As a matter of fact, should those auto complete addresses be lost, most users would be more than willing to beat the tar out of any IT guy that comes too close. Oddly enough, most IT staff aren’t aware that this auto complete list can be backed up with relative ease. The auto complete information is actually stored in its own file which can be backed up and transferred to another computer if necessary. This file is located at C:\Documents and Settings\username\Application Data\Microsoft\Outlook\profilename.nk2.

How to type Hindi and ગુજરાતી in Windows Xp and Windows Vista

 : How do I type in Gujarati Unicode on my computer ? I have a windows XP as an operating system on my computer.

Following step will work ONLY if you have Windows XP (it does not matter whether you have Home edition or Professional edition). If you don’t have win XP, please don’t trouble yourself. Keep Win XP Installation CD ready with you.

STEPS

01. Go to Start > control panel > Date Time Language and Regional Options > Regional and language Options. 

02. Once open, click on the languages tab and in the bottom half select both check boxes for support for east asian language and right-to left language.

03. A box will pop up that will tell you that you will need some space 230 MB or something. Click ok. And then click apply. 

04. It will ask for Windows XP CD. Put in CD drive or give path. At the end of the file copy, it will tell you to restart. Do it.

05. Upon reboot, Go again to Start > control panel > Date Time Language and Regional Options > Regional and language Options.

06. Once open, click on the languages tab and in the top half select Details in Text service and Input languages.

07. Text service and Input Language box has two tabs. In the settings tab in the second half of installed service Add > (in the box that opens select Input language as Gujarati and keyboard as Gujarati) and then click OK. You will be back on 'Text Service and Input Language' window.

(Note: If you don't find Gujarati here, you haven't correctly followed above steps. You can also select Hindi or Devnagari in step 7 the same way.)


08. Now go to Preferences > Language Bar > make sure that first and third checkbox are selcted : 'Show the language bar on the desktop' and 'Show additional Language bar icon on the desktop'. 

(Note: They should be selected by default. If not select them)

09. Go to Key settings > Make following selections

To Turn off CAPS LOCK > Press CAPS LOCK (natural choice !)

Click Hot Keys for Input Language and

Key sequence for Change Input Language : Control + Shift key

(so If you accidentally hit this combination, your language will change!)

10. Click OK. You will be once again on 'Text Services and Input Languages window. Ok and close all windows. You are done !
Verify that it works !

- Open Microsoft word, type K C N …it will show up as kcn. 

- Next, either use left Control + Shift or select language from small icon on the task bar on your desktop to change language (you should see in your taskbar the two letters change from EN to GU ) 

- Type same keys K C N ..you should see કમલ . 

- Change back to English and verify that same key shows K C N ! 

 

Welcome to the world of Gujarati on net !

Capture rapnge in Worksheet as Picture

To capture the range as an image use

range("A1:C10").CopyPicture xlScreen,xlBitmap 

To do this manually select the range A1:C10 and the whilst holding the shift key use the menu Edit. You should see a new menu item Copy Picture. The dialog allows you to specify picture or bitmap, screen or printer version.

Wednesday, December 3, 2008

List All the Name and other Information of the File in Folder and Sub Folder

The following Macro lists the all detail of the file in folder and subfolder

'*****************************************************************

Sub TestListFilesInFolder()
  Workbooks.Add ' create a new workbook for the file list
  ' add headers
  With Range("A1")
  .Formula = "Folder contents:"
  .Font.Bold = True
  .Font.Size = 12
  End With
  Range("A3").Formula = "File Name:"
  Range("B3").Formula = "File Size:"
  Range("C3").Formula = "File Type:"
  Range("D3").Formula = "Date Created:"
  Range("E3").Formula = "Date Last Accessed:"
  Range("F3").Formula = "Date Last Modified:"
  Range("G3").Formula = "Attributes:"
  Range("H3").Formula = "Short File Name:"
  Range("A3:H3").Font.Bold = True
  ListFilesInFolder "C:\FolderName\", True 
  ' list all files included subfolders
End Sub


Sub ListFilesInFolder(SourceFolderName As String, IncludeSubfolders As Boolean)
' lists information about the files in SourceFolder
' example: ListFilesInFolder "C:\FolderName\", True
Dim FSO As Scripting.FileSystemObject
Dim SourceFolder As Scripting.Folder, SubFolder As Scripting.Folder
Dim FileItem As Scripting.File
Dim r As Long
  Set FSO = New Scripting.FileSystemObject
  Set SourceFolder = FSO.GetFolder(SourceFolderName)
  r = Range("A65536").End(xlUp).Row + 1
  For Each FileItem In SourceFolder.Files
  ' display file properties
  Cells(r, 1).Formula = FileItem.Path & FileItem.Name
  Cells(r, 2).Formula = FileItem.Size
  Cells(r, 3).Formula = FileItem.Type
  Cells(r, 4).Formula = FileItem.DateCreated
  Cells(r, 5).Formula = FileItem.DateLastAccessed
  Cells(r, 6).Formula = FileItem.DateLastModified
  Cells(r, 7).Formula = FileItem.Attributes
  Cells(r, 8).Formula = FileItem.ShortPath & FileItem.ShortName
  ' use file methods (not proper in this example)
' FileItem.Copy "C:\FolderName\Filename.txt", True
' FileItem.Move "C:\FolderName\Filename.txt"
' FileItem.Delete True
  r = r + 1 ' next row number
  Next FileItem
  If IncludeSubfolders Then
  For Each SubFolder In SourceFolder.SubFolders
  ListFilesInFolder SubFolder.Path, True
  Next SubFolder
  End If
  Columns("A:H").AutoFit
  Set FileItem = Nothing
  Set SourceFolder = Nothing
  Set FSO = Nothing
  ActiveWorkbook.Saved = True
End Sub

'***************************************************************

Using F4 and Shift F4 key for finding in Excel

It becomes annoying to have find dialogue box while searching in front of the view. The following trick shows that we can hide the find dialogue box and still search. 

1. Use the Find option from the Edit menu as normal, specifying what I want to search for and then looking for the first occurrence.

2. When the first occurrence is displayed, I press the Esc key (or click on Cancel). The Find dialog box disappears.

3. To find the next occurrence, I press Shift+F4.

This procedure works the same as clicking Find Next repeatedly, and it is just as fast, but it gets rid of the annoying Find dialog box.

Wednesday, November 26, 2008

Task Manager Not Starting - Error 1717

In windows xp professional & windows 2000, We were not able to start Task Manager and received error message 1717, this error was resloved by starting 'Event Log' Service in Administrative services.

run -> Services.msc -> Start Event Log Service and then Task Manger Service.

Sending Large Attachment File via E-Mail


It was a great problem in sending large file more then 2 mb via email (as it is restriction imposed most of the ISP), for this either we have to use, our yahoo mail pro account or get some other arrangment.

As yahoo mail pro account is only accessible only to me, it becomes necessary to have alternate arrangement for the staff for sending file larger then 2 mb through regular e-mail server (bsnl server in our case).

After taking trial of number of softwares like pando, beamfile etc we zero on www.yousendit.com.

Yousendit comes with good features and it has (a) Desktop software for sending the file directly from computer, (b) Microsoft Outlook Plugin to send the file directly from Microsoft Outloook, (d) web interface, this becomes very convinent for s

Today, Ronak was trained how to use yousendit from Microsoft Outlook, desktop and web.

Tuesday, November 25, 2008

Basis of Surveying by Using Total Earth Station.

Using of total station and working with the surveyor on the site for the young and in-experience Civil Engineer is a nightmare.

The principle of surveying with Total Station is a technique which most of the fresh graduates does not understand and have to rely on the Sr. Surveyor or the field staff where there are full chances that they can be mis-guided.

This was the issue I address when I took up the project for the preparation of DPR at Bihar where my young team of surveyor was blind in deciding the new alignment. The team was in no direction because they were desserted by the Sr. Surveyor.

I have to address this issue with then surveyor Mr. Rajeev who now works in my office as my assistant. 

The extensive study with the survey team at bihar resulted for me in collection of some of the information how a survey work can be carried out and what kind of correction we should apply for the correct survey.

visit the site www.ncon.in/survey.htm to download the file which focuses in basic learning of the surveying work which can be life time assets for the inspiring young civil engineers.

Monday, November 24, 2008

Windows File Name

Naming Files in Windows According to Ed Bott and Woody Leonhard the following are the requirements for Windows filenames:

1. A filename may contain any alphanumeric character, including the letters A to Z and numbers from 0 to 9.

2. The full filename (including drive letter, colon, backslashes, and folder names) may be as long as 255 characters.

3. The filename itself may be as short as one character.

4. The following special characters are allowed in a filename:   $ % - _ @ ~ ` ' ! ( ) ^ # & + , ; = . [ ] { }

5. Spaces are allowed in filenames.

6. The following special characters are prohibited from being a part of a filename because they have special meanings to the operating system (DOS underlying Windows):
  / \ | : * ? " < >

You'll get an error message if you try to use one of them.

Windows files (and Office files in particular) typically include a three-letter extension, which is added automatically by the program that created the file (such as .doc for files created by Word). However, an extension is not required, nor are extensions limited to three characters. Windows treats any characters following the last period in the filename as an extension.

Source: Special Edition Using Office 2000 by Ed Bott and Woody Leonhard., pp. 73-74 Que. (paraphrased slightly)

Although the above are requirements, they have a couple of recommendations or notes:

  1. They recommend limiting the name of the file itself to about 40 characters so that you don't have trouble moving files with deeply nested folders.
 

2. If you use a nonstandard extension you may have difficulty opening the file from Windows. In Microsoft Office programs files with nonstandard extensions will not appear in file dialog boxes unless you change the file type to All Files.

  3. Windows filenames are not case sensitive. MyFile.doc is treated the same as MYFILE.DOC and myfile.doc. However, if you are publishing to a web page, the web server may be using a different operating system that does pay attention to case.

  4. Word marks temporary files with a beginning tilde (~) character. I would recommend not using this as the beginning character for any file that will be used by any of the MS Office programs.

Adding Commands in Shortcut Menu in Words

Right-click menus

Are you a fan of the shortcut menus that appear when you alternate mouse click? Alternate-clicking on different items provides great shortcuts to accomplishing frequently used tasks. Microsoft places frequently used commands on these menus but you can set them up to access the commands that you use the most by following these steps:

Alternate-click on any toolbar button. Select Customize from the menu that is displayed. Select the Toolbars tab. Scroll to the bottom of the list and select the Shortcut Menus toolbar. The Shortcut Menus toolbar will appear within your workspace. Select the Commands tab. Locate a command that you want to add to a shortcut menu. When you find a command that you use often (and does not already appear when you alternate click), click and drag it onto one of three positions on the Shortcut Menus toolbar. 

The Text position contains all of the shortcut menus when you alternate click on text. If you choose to add your command to the Text position, a submenu will display and you can select which shortcut menu you need. For example, to add something to the shortcut menu that appears when you alternate click on a misspelled word, select Text and then select Spelling. 

Additions to the Table position on the Shortcut Menus make this command accessible when you alternate click on a table. 

The Drawing position makes the command accessible when you alternate click on a drawing object. 

Close the Customize dialog box and alternate click to see your result.

Selecting Text using Mouse and Shift Key.

You already know that you can use the mouse to select text by holding down the left mouse button and dragging the mouse to make a selection. There is an even quicker way to select text using the mouse, however. This is done in the following manner:

Position the insertion point where you want the selection to begin. 

Move the mouse cursor so it points to where you want the selection to end. 

Hold down the Shift key as you click once on the left mouse button. 

Removing Style from the Document:

This is where a macro comes in handy. It can quickly search through a document to see if a particular style is used anywhere. If it isn't, then the style can be easily deleted. The following macro,

DeleteUnusedStyles,  does just that.

'************************************************************************************
Sub DeleteUnusedStyles()
  Dim oStyle As Style

  For Each oStyle In ActiveDocument.Styles
  'Only check out non-built-in styles
  If oStyle.BuiltIn = False Then
  With ActiveDocument.Content.Find
  .ClearFormatting
  .Style = oStyle.NameLocal
  .Execute FindText:="", Format:=True
  If .Found = False Then oStyle.Delete
  End With
  End If
  Next oStyle

End Sub

'**********************************************************************************

Note that the macro ignores a style if it is a built-in style.

This is because deleting a built-in style doesn't really delete it, but only resets that style to its original, default condition. In fact, Word doesn't allow built-in styles to be deleted from a document. Even if the built-in style is no longer used, but was once used in the document, it will still show up in the styles drop-down list. If this bothers you, there are additional steps you can take to "delete" the listing of these built-in styles. These steps can be rather involved, and are best described in Knowledge Base article KB193536:


http://support.microsoft.com/default.aspx?scid=kb;en-us;193536

Pasting Text from Internet in Microsoft Word

Ever try to copy and paste text from the internet into MS Word only to paste all the formatting along with it? Most pages are tables without the grid lines showing. If you copy something from an internet page and try to paste it in MS Word, the default paste is to paste formatting and all. You'll save tons of time removing the formatting.

Try clicking on

  * Edit
  * Paste Special
  * Choose unformatted text.

If you do happen to have a document that you need to just remove all the formatting and start from scratch:

  * Select the text you want to remove formatting from
  * Click the style tool dropdown arrow on the formatting tool bar
  * Clear formatting

Pasting Text from Internet in Microsoft Word

Ever try to copy and paste text from the internet into MS Word only to paste all the formatting along with it? Most pages are tables without the grid lines showing. If you copy something from an internet page and try to paste it in MS Word, the default paste is to paste formatting and all. You'll save tons of time removing the formatting.

Try clicking on

  * Edit
  * Paste Special
  * Choose unformatted text.

If you do happen to have a document that you need to just remove all the formatting and start from scratch:

  * Select the text you want to remove formatting from
  * Click the style tool dropdown arrow on the formatting tool bar
  * Clear formatting

Drag Data Between Excel Worksheets

Have you ever tried to drag and drop data from one worksheet to another in MS Excel?

What happened?

I just bet that you started dragging that information towards the sheet tabs (looking to switch between worksheets) and were stunned to find that all the worksheet wanted to do was zoom off to some extremely high row number.

Now what?

Many people use Ctrl + Page Up/Down to move between sheets but if you're in the middle of a drag that won't work.

Some people just use the Cut/Paste routine which absolutely works but what if that's not your first instinct? What if the drag and drop is just the way you naturally work? Is there a solution for you?

I'm glad to report that the answer is yes.

Next time you're dragging the data, simply hold down the Alt key and the scrolling will stop.

Once you've got the scrolling stopped you'll find that you're allowed access to the sheet tabs.

While still holding the mouse button as a part of the drag, highlight a different sheet tab and poof!

You're on a different worksheet where you can easily complete the "drop" part of the data movement using your preferred method.

Simple Operation to Repair Microsoft Excel

Running Excel with the /regserver switch will cause Excel to rewrite all of its keys in the system registry. That rewrites all of the class ids for all the controls and objects back to the registry, overwriting any values that may have become corrupt. In addition all library files and type library get reassociated correctly.

It doesn't replace all of the actual libraries file like a real install does, but it rebuilds all the associations between those libraries and objects with the "factory defaults". It cannot fix a file because it doesn't alter the files, but can repair a faulty "reference" to a DLL, or something pointing to the wrong library.

This method can cure lots of odd problems with Excel, and is far easier and safer than doing a real re-install of the program. You don't have to worry about losing your toolbars etc. Before you ever do a full re-install, you should always run Excel with the /regserver switch as it may save you a lot of time and trouble.

(Press Windows Key + R, then type Excel /regserver to reset the registry)

[Comments from Chip Pearson via Excel.Programing Newsgroup]

Share your Internet Favorites with other systems in a Workgroup

If you want to share your Internet shortcuts (Favorites) with the other computers in your Workgroup, follow these instructions:

Requirements: Any PC running a Windows Operating System with File and Printer Sharing enabled. Additionally, if you want to synchronize the Favorites, Windows XP Professional is required. 

  *    Decide which computer must host the Favorites (Let's call it as Source computer)
  *  Share the Favorites folder and give Full Access to the share
  *  In other systems, map a drive-letter for the shared Favorites folder
  *  Change the Favorites Shell Folder paths in the registry for the other computers in the Workgroup pointing to Source Computer's Favorites folder
  * Make use of Offline Files feature to Synchronize the Favorites (this feature requires XP Professional) 

Decide which computer must host the Favorites (Source computer)

If the Workgroup contains 10 computers, decide which computer you want to designate as the Host. Hint: Choose the computer which will be ON always or most of the times, for high availability of Favorites for other systems.

Share the Favorites folder and give Full Access to the share

Depending upon the Operating System installed in the Source Computer, right-click the Favorites folder and Share it (give Full Access rights for this share). Note that you may need to install File and Printer Sharing for Windows 98/ME systems additionally.

In other systems, map a drive-letter for the shared Favorites folder

From other Workgroup systems, access the Favorites share of the Source Computer and assign the same drive-letter (say Z:\ ) in all the computers, for uniformity. 

Change the Favorites Shell Folder paths in the registry for the other computers

For each computers in the Workgroup (except the Source Computer), change the User Shell Folders path in the registry for Favorites. This has to be done in the following registry key:

HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\User Shell Folders

Set the value of "Favorites" to "Z:\"

You may try FolderRedirector utility to automate the process.

Now, open an instance of Internet Explorer to verify that the Favorites list is read from the Source Computer's Favorites list. You're done now. The next step is to keep the Favorites synchronized.

Make use of Offline Files feature to Synchronize the Favorites (this part requires XP Professional)

Offline Files in Windows XP Professional can help you be more productive. You can use this feature on a portable computer, or on a desktop computer that occasionally connects to your workplace network. For example, this feature is useful if you are working at home on a desktop computer, and need to automatically get files off the network whenever you connect.

The files that you select are automatically downloaded from shared folders on the network and stored on your computer. When you disconnect, the files are available to use. When you reconnect to the network, your changes are added to the files on the network in a process called synchronization. If someone else on the network made changes to the same file, you can save your version, keep the other version, or save both.

Well. To enable Offline Files feature for the shared Favorites folder, type Z:\ in the RUN dialog. Click Tools, Folder Options and click Offline Files tab. Enable the following checkboxes:

  *  Enable Offline files
  *  Synchronize all Offline files when logging on
  *  Synchronize all Offline files before logging off 

If your Source Computer is unavailable, the other computers use the cached (Offline Files) favorites instead. Same occurs if the other computers are disconnected from the Workgroup. 

To launch the Synchronization Wizard manually, type mobsync in the RUN box and synchronize the Offline Files Favorites whenever you want. You can also configure the system to Sychronize the Offline Files when the system is idle. Wonderful features!

Using Named Range in Visual Applications (macros) in Excel

I have a named range (Account) defined in a workbook, and I was wondering how to access and use that named range from within a macro.

After taking help and browsing the web i was able to find out several ways we can access the range, using either the Range object or the Names collection.


To access the named range using the Range object, all you need to do is provide the name of the range as a parameter to the object. This name is the same one that you defined within Excel. For instance, the following line could be used to change the interior color of the entire range:

Worksheets("Sheet1").Range("Account").Interior.Color = vbYellow


Note that the Range object is used relative to a particular worksheet, in this case Sheet1. You could also define a range object within VBA and then assign it to be equal to the named range, in this manner:

Set rng = Worksheets("Sheet1").Range("Account")
The other method of using the named range is to use the Names collection. The following line will again set the interior color of the range to yellow:

Workbooks("Book1.xls").Names("Account").RefersToRange.Interior.Color = vbYellow

Note that the Names collection is relative to the entire workbook, so it is not necessary to know which worksheet the named range is associated with when you use this method of access. You can also define a range object in VBA and assign it to be the same as the named range:

Set rng = Workbooks("Book1.xls").Names("Account").RefersToRange

You should know that the Names collection method of accessing a named range will only be viable if you don't have the same named range defined on different worksheets in the workbook. If you do, then you will need to use the Range object method, which requires the use of a specific worksheet name in the reference.

Delete Duplicate Rows in Excel

This code works very nice which deletes the duplicate rows in given set of data.

Sub DelDups() 

' Deletes duplicate rows in the selected range. 
' All columns in the selected range must be identical for 
' a row to be deleted. The entire row, not just the selected 
' cells in the row, will be deleted if a duplicate is found. 
' The first instance of the duplicate row is the copy that 
' will be retained. 

  Dim iRow As Long 
  Dim jRow As Long 
  Dim iCol As Integer 
  Dim LastRow As Long 'The last row in the selected range 
  Dim FirstRow As Long 'The first row in the selected range 
  Dim FirstCol As Integer 
  Dim LastCol As Integer 
  Dim DelCount As Long 'The count of duplicate rows removed 
  Dim DupFound As Boolean 'True if duplicate row found 
   
  DelCount = 0 
   
  FirstRow = Selection.Row 
  LastRow = FirstRow + Selection.Rows.Count - 1 
  FirstCol = Selection.Column 
  LastCol = FirstCol + Selection.Columns.Count - 1 
   
  For iRow = FirstRow To LastRow - 1 
   
  For jRow = iRow + 1 To LastRow 
   
  DupFound = True 
  For iCol = FirstCol To LastCol 
  DupFound = DupFound And (Cells(jRow, iCol) = Cells(iRow, iCol)) 
  If Not DupFound Then Exit For 
  Next iCol 
  If DupFound Then 
  ' Duplicate row found--delete it 
  Rows(jRow).Delete 
  LastRow = LastRow - 1 
  DelCount = DelCount + 1 
  End If 
   
  Next jRow 
   
  Next iRow 
   
  Beep 
  MsgBox DelCount & " duplicate rows deleted.", _ 
  vbInformation, "Duplicate Removal Results" 

End Sub 


Capturing Image from the Screen

I have written this trick to be used in excel or any program but I advice to use instead 'Turbonote' procedure as explained and taught which is quiet simple and more robust.

There may be times when you need to include a screen shot within your Elxcel worksheet. The easiest way to do this is as follows:


Set up your screen to look the way you want it to. 
Press the PrintScreen key. This copies the screen to the Clipboard. 
Start Excel (if it is not already started) and select the cell closest to where you want the screen to appear. 

Press Ctrl+V to paste the contents of the Clipboard. 

This action results in the entire screen being pasted in your worksheet. If you wanted, instead, to only copy and paste a single dialog box or the active window, simply use Alt+PrintScreen in step 2.

If either of these methods still does not fit your needs (for instance, you want to include only a small part of the screen), you can use the following:

Set up your screen to look the way you want it to. 
Press the PrintScreen key. This copies the screen to the Clipboard. 
Start the Paint accessory (or some other graphics program, such as Paint Shop Pro) and maximize the screen. 

Press Ctrl+V to paste the contents of the Clipboard into the program. 

Use the program's editing tools to change the image as desired. 
When complete, press Ctrl+C to copy the image to the Clipboard. 
Start Excel (if it is not already started) and select the cell closest to where you want the screen to appear. 

Press Ctrl+V to paste the contents of the Clipboard. 

You should understand that once the screen is placed in your workbook, you can move and manipulate it the same as any other graphic.

Also note that adding quite a few graphics to your worksheet can dramatically increase the size of the file in which your workbook is saved.

Minimizing Window while working

This is a small trick which is very useful to maintain our privacy while working in the office.

Use key window + D -->> to minimize all the windows.

press again by

using key window + D ---> to show all the windows.

I am sure this great short cut to be used in windows.

Mumbai visit on 4.11.2008

Immediately after Diwali Vacation we had a meeting with propective investors in mumbai. Ronak was directed to pick a available vehicle and reach mumbai. I and Rajeev after touring maharastra reached directly to Mumbai.


Ronak Enjoying the View of Arabian See from ICT Hotel

We stayed in hotel near mumbai and Ronak joined us at the Hotel. 

We had a lunch in ICT Hotel - Marine Lines where our meeting was scheduled.

Custom Format Cells

Working with excel one of the main problem we face how to custom format the cell. That means how to show 12 as 00012 or 123 as 00123.

There is also an issue how to only show month in different forms.

Another issue is how to pre-fix or suffix custom text with the number in the cell. 

The file 'custom format cell' can be downloaded from

www.ncon.in/excel.htm ('custom format cell')

which demonstrates the use of Tricks where you can custom format the cell.

Excel has powerful function for custom formats only you need to learn and understand how to use it.

Sunday, November 23, 2008

Our Visit to Mumbai


We visited Mumbai for project proposal with prospective investors. At mumbai we had a nice time talking to prospecitve investors at Oberoi - New Mumbai.

Rajeev Smiling before Meeting



In Picutre you can see My Personal Assistant Mr. Rajeev Mahato, before meeting at waiting lounge of Oberoi Trident.

Using Index, Match, Vlookup, Hlookup, Lookup Function

The Example on www.ncon.in/excel.htm download section Demonstrates the Use of Vlookup, Combination ofMatch and Index , Offset and Match Function to get the value from the table.You can learn more about this function by taking online Help.

I will prefer to use Index-Match or Offset Function Instead ofusing Vlookup, Hlookup or Lookup functions.

Here I have shown two methods one is by using of cell references and other by Naming the range and then using Name range to get the data.

It depends on individual choice what to use.This example does not demonstrate the use of Dyanamic Range.It is because I presume let us first understand function and then goto advance stage.

Sheet2 of example demonstrate How you can use Form controls to reterive the value with combination of INDEX - MATCH and OFFSET - MATCH function.Last to say , if you prefer to use VLOOKUP or HLOOKUP function then you need to sort the data. For INDEX - MATCH, OFFSET - MATCH you donot require that so you can go on adding data to your range and can use dynamic range to get data.

Next week we shall discuss of dyanmic range, I already have example file of 'Dynamic Range' which can be download from the website, www.ncon.in/excel.htm.

Sunday, November 16, 2008

Strip Attachement from Outlook

There are lots of macros which can be used to strip the attachment from the messages stored in outlook.. here is a sample code which we use for our office..
*****************Strip Outlook Attachements*******************************
you can download this from

www.ncon.in/outlook.htm

It is very useful function.

Minimizing Outlook in Notification Area

Can Outlook minimize to the Notification Area*?
This is possible with Outlook 2002 when you add a registry setting and is even the default for Outlook 2003 (rightclick the Outlook icon in the Outlook icon in the Notification Area and deselect "Hide when minimized" to toggle it). For previous versions of Outlook you'll need to use third party software like Actual Title Buttons which lets you minimize every possible window to the Notification Area or download HideOutlook just for Outlook.
For Outlook 2002;
1. Make sure Outlook is closed. 2. Open your registry editor by opening the Run command and type regedit (regedt32 for Windows 2000) 3. Locate the following key; [HKEY_CURRENT_USER\Software\Microsoft\Office\10.0\Outlook\Preferences] 4. Goto Edit-> New-> DWORD Value. 5. Name the value MinToTray (case sensitive!) 6. Double-click on the newly created value and give it the value of 1 7. Press OK on the input box and close the registry editor 8. When you open Outlook an Outlook icon is displayed in the Notification Area. Press the minimize button and Outlook will stay in the Notification Area. Doubleclick on it to open Outlook.
*The Notification Area in Windows XP is what the System tray was in previous versions of Windows

Using rmdir instead Deltree

Deltree was removed from XP... try rmdir /s from the command line.

Turn Off Display of Friendly Errors

http://windowsxp.mvps.org/iefaq.htmhttp://ecross.mvps.org/
To turn off friendly HTTP error messagesClick the Tools button, and then click Internet Options.Click the Advanced tab, and then scroll down to the Browsing section.Clear the Show friendly HTTP error messages check box, and then click OK.

75 Essential Microsoft Excel Tips

Click on the file to find out the 75 essential microsoft excel Tips.

www.ncon.in/excel.htm

Nishith Desai

Diwali Puja in Office







It was a diwali time and we started our celebration with doing puja in office. Whole of my family attented the Puja. It was for the first time that Rajeev, Maulik and Ronak participated in puja.



We all missed Utpal as he joined another company.



Diwali marks the starting of the Diwali Holidays and time to enjoy sweets with family and friends.

List File in a folder using VBA in Microsoft Excel

Microsoft Scripting Runtime is included in these products:  
Windows98, Windows2000, IE5, and Office2000.  
The macro examples below assumes that your VBA project has added a reference to the 
Microsoft Scripting Runtime library.  
You can do this from within the VBE by selecting the menu Tools, References and selecting 

Microsoft Scripting Runtime.  

********************** Code**************************************************************************

Sub TestListFilesInFolder() 
  Workbooks.Add ' create a new workbook for th
  ' add headers 
  With Range("A1") 
  .Formula = "Folder contents:" 
  .Font.Bold = True 
  .Font.Size = 12 
  End With 
  Range("A3").Formula = "File Name:" 
  Range("B3").Formula = "File Size:" 
  Range("C3").Formula = "File Type:" 
  Range("D3").Formula = "Date Created:" 
  Range("E3").Formula = "Date Last Accessed:" 
  Range("F3").Formula = "Date Last Modified:" 
  Range("G3").Formula = "Attributes:" 
  Range("H3").Formula = "Short File Name:" 
  Range("A3:H3").Font.Bold = True 
  ListFilesInFolder "C:\FolderName\", True 
' list all files included subfolders 
End Sub

****************************** Code 2***************************************

Sub ListFilesInFolder(SourceFolderName As String, IncludeSubfolders As Boolean)
' lists information about the files in SourceFolder 
' example: ListFilesInFolder "C:\FolderName\", True 
Dim FSO As Scripting.FileSystemObject 
Dim SourceFolder As Scripting.Folder, SubFolder As Scripting.Folder 
Dim FileItem As Scripting.File 
Dim r As Long 
  Set FSO = New Scripting.FileSystemObject 
  Set SourceFolder = FSO.GetFolder(SourceFolderName) 
  r = Range("A65536").End(xlUp).Row + 1 
  For Each FileItem In SourceFolder.Files 
  ' display file properties 
  Cells(r, 1).Formula = FileItem.Path & FileItem.Name 
  Cells(r, 2).Formula = FileItem.Size 
  Cells(r, 3).Formula = FileItem.Type 
  Cells(r, 4).Formula = FileItem.DateCreated 
 Cells(r, 5).Formula = FileItem.DateLastAccessed 
  Cells(r, 6).Formula = FileItem.DateLastModified 
  Cells(r, 7).Formula = FileItem.Attributes 
  Cells(r, 8).Formula = FileItem.ShortPath & FileItem.ShortName 
  ' use file methods (not proper in this example) 
' FileItem.Copy "C:\FolderName\Filename.txt", True 
' FileItem.Move "C:\FolderName\Filename.txt" 
' FileItem.Delete True 
  r = r + 1 ' next row number 
  Next FileItem 
  If IncludeSubfolders Then 
  For Each SubFolder In SourceFolder.SubFolders 
  ListFilesInFolder SubFolder.Path, True 
  Next SubFolder 
  End If 
  Columns("A:H").AutoFit 
  Set FileItem = Nothing 
  Set SourceFolder = Nothing 
  Set FSO = Nothing 
  ActiveWorkbook.Saved = True 
End Sub
Thunderbird does not provide any way to create signature files. Use your operating system tools to create them—for example, use a plain text editor.

Thunderbird does not provide any special place to store signature files.

You could create a Signatures directory in your profile to store them, making them easy to back up along with the rest of your profile. Or you could store them somewhere else.

You can get more information regarding this aspect by clicking the link below

http://kb.mozillazine.org/Signatures_(Thunderbird)


ISO Paper Size

There had been lots of confusion in the engineering and staff about the size of the paper. Person wanted to know the what is the size of A4 or A3. 

In this context we surfed the web and found very good link which was very informative to let understand the size of paper.

This information was again verified with other poster and other internet information. Still we welcome suggestion on this.

You can download this file by clicking here.

Above file is a PDF showing the information we collected from

http://www.cl.cam.ac.uk/~mgk25/iso-paper.html

Nishith Desai

Saturday, November 15, 2008

Rajeev Birthday on 11.11.2008




Today it was Raju's birth day and office staff celebrated it by cutting the cake. The party was hosted by Raju and we had a wonderul time in dining at Jungle Book - Reaturant. My all wishes with Rajeev.

Rajeev Birthday on 11.11.08

Saturday, March 1, 2008

Removing quick info virus

To delete the value from the registryImportant: Symantec strongly recommends that you back up the registry before making any changes to it. Incorrect changes to the registry can result in permanent data loss or corrupted files. Modify the specified subkeys only. For instructions refer to the document:
-----------------------------------------
Click Start > Run.
Type regedit
Click OK

-----------------------------------------
Note: If the registry editor fails to open the threat may have modified the registry to prevent access to the registry editor.
Navigate to the subkey:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Run
In the right pane, delete the values:


"Task Manager" = "%Windir%\svchost.exe""Yahoo Messenger" = "%Windir%\system\svchost32.exe"

Navigate to the subkey:

HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Policies\Explorer
In the right pane, delete the value:"NoRun" = "1"
Navigate to the subkey:HKEY_CURRENT_USER\Software\Policies\Microsoft\Internet Explorer\Control Panel
In the right pane, delete the value:"Homepage" = "1"
Navigate to the subkey:HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Policies\System
In the right pane, restore the original values:"DisableTaskMgr" = "1""DisableRegistryTools" = "1"
Navigate to the subkey:HKEY_CURRENT_USER\Software\Microsoft\Internet Explorer\Main
In the right pane, restore the following entry to its previous value:"Start Page" = "[http://]quicknews.info"
Navigate to the subkeys:HKEY_CURRENT_USER\Software\Yahoo\pager\View\YMSGR_buzzHKEY_CURRENT_USER\Software\Yahoo\pager\View\YMSGR_Launchcast
In the right pane, delete the value:"content url" = "[http://]quicknews.info"
Exit the Registry Editor.

Writeup By: Kazumasa Itabashi