NCON - INFRASTRUCTURES

My Visit to Washington DC

2009-08-10T07:56:00.000-07:00

I was really very excited at the my first eye contact with the White House and was really amazed by its simple grandeur and beautiful Landscape one desires to experience. White House was simply fascinating.

I visited Ronald Reagean International Centre in the afternoon and was able to see the grandeur and the beautiful hardscape and landscape of the campus. A party was organized for some state guest with wonderful decoration which I shall always remember. While leaving the centre I show the remnant of the dividing wall of west and east germany.

My visit to Capitol started on 11th August in evening after visiting Madame Tussauds Wax Musuem and Ford Theatre where Mr. Linclon was assassinated.

My visit to Washington was a good experience and was able to understand the capital of USA. Washington is very clean and quiet city with beautiful monuments and Musuems to see.

Nice Gujarati Poem dedicated to Parents

2009-03-12T04:05:00.000-07:00

Today one of my friend Mr. Rupang Mehat - CEO Intas Pharma forwarded me a very nice poem in gujarati which I shall like to share with the community.

It is really a heart touching peom.

Visit to Tulsa - Chicago

2009-03-07T17:12:00.000-08:00

I visited Tulsa - Oklahoma in USA to meet some business friends. It was really nice to see the city from my plane. I found city in a plain terrian and full of grass.

City is very cute, clean and beatiful. It has wonderful landscapes and beautiful planning. The roads are well planned and the buidlings seems to be constructed in well tought manner.

I have to go back to Philadelphia via chicago and it took 12 hours to reach to philadelphia.

In the craft it was nice oppurtunity to meet one upcoming band from chicago called 'Kill Hannah'. I browse the net to see what they do. I was interesting that they have good presence in international market, this the link you can find about them http://www.myspace.com/killhannah

My stay in USA

2009-03-07T16:51:00.000-08:00

I been moving on the states for while and it was very interesting to talk with my office by using skype.

We are using skype and have setup video conference in our office so that we remain in touch with my office collegues.

It is really a wonderful way to work and to look after office work.

Bihar Visit - 2006-2007

2009-01-11T05:50:00.001-08:00

Visit to Bihar - Life Time Experience

Standing with Mr. Jha - NHAI Officer and My Team

My project in Bihar was simply the exciting experience of the life. I spend lovely 15 days during the preparation of project report for Patna Muzzaffarpur NH-77. I found people to be intelligent, simple, hard working and true to the heart.

Celebrating 2007 - With Pinku - Rajeev - Ravi

Bihar is the best place for cycling in the district of muzzaffarpur where you will find brick paved roads in the gardens of Licthe. Muzzaffarpur is consider as the head quater of Licthe in India.

It was wonderful experience while having Bihar Tradition Food at Ravi's House in the night with charcoal burning and kohara in the atmosphere.

Lithi Chokha - Traditional Food of Bihar

Lithi is prepared in wheat flour with chickpeas stuffing and cooked in charcoal and served with Cooked Chopped Bringle with tradional Indian Curry.

Yellow Rose in Bihar

2009-01-11T05:41:00.000-08:00

Yellow Rose in Buddha Garden - Bihar

While touring in India I have not seen the beautiful roses as seen in the Stupa of Buddha in Bihar. The garden has grown some of the wonderful roses grown in natural environment. The rose displays full blossom of the rose in Bihar.

2009-01-09T10:24:00.000-08:00

Puspak Towers

Puspak Towers were developed by me in 1997 and was one of the most successful project. It has 60 Apartments and the cost of the project at value of 2009 is 2.5 Million USD or 120 Million INR.

Paras - Perennial Flower of Gujarat

2009-01-09T10:14:00.000-08:00

Paras

Para is flower which loved by Lord Krishna. It is common flower grown in the Home Gardens in Gujarat and overall in India. It gives good fragance in night and it has very delicate look.

SEPTA

2009-01-06T14:23:00.000-08:00

www.septa.org

The Southeastern Pennsylvania Transportation Authority (SEPTA) provides public transportation services in Bucks, Chester, Delaware, Montgomery and Philadelphia County, along with selected rail service to the State of New Jersey and Delaware.

Anand Boriavi

2009-01-06T01:57:00.000-08:00

Site Visit on 5.01.2009

We visited Anand Boravi on 5th January 2008 and took some pictures. It was nice to observe that we show some progress on the site and are now hopeful that contractor will resume the work for the construction of R.E. Wall.

Online Bank to Bank Transfer - NEFT

2008-12-19T09:50:00.000-08:00

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

2008-12-19T09:47:00.000-08:00

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

Adams Mark
AmeriSuites
Ayres Hotels & Suites
Club Med
Club Quarters
Coast Hotels & Resorts
Courtyard by Marriott
Crowne Plaza
Four Points
Hawthorn Suites
Hilton Garden Inn
Homewood Suites
Novotel
Outrigger Hotels & Resorts
Radisson
Residence Inn by Marriott
ResortQuest Hawaii
Sierra Suites
SpringHill Suites
Staybridge
Summerfield Suites by Wyndham
Woodfield Suites
Woodfin Suite Hotels
Wyndham Hotels & Resorts

Quicker Way to Launch Program

2008-12-19T09:45:00.000-08:00

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

2008-12-19T09:44:00.000-08:00

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

2008-12-19T09:43:00.000-08:00

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

2008-12-19T09:39:00.000-08:00

: 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

2008-12-19T09:35:00.000-08:00

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.

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

2008-12-03T19:09:00.001-08:00

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

2008-12-03T19:01:00.000-08:00

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.

Task Manager Not Starting - Error 1717

2008-11-26T00:37:00.000-08:00

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

2008-11-26T00:07:00.001-08:00

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.

Basis of Surveying by Using Total Earth Station.

2008-11-25T01:27:00.000-08:00

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.

Windows File Name

2008-11-24T19:17:00.000-08:00

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

2008-11-24T19:15:00.000-08:00

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.

2008-11-24T19:08:00.001-08:00

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:

2008-11-24T19:05:00.000-08:00

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

2008-11-24T19:02:00.001-08:00

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

2008-11-24T19:02:00.000-08:00

Drag Data Between Excel Worksheets

2008-11-24T18:59:00.001-08:00

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

2008-11-24T18:54:00.001-08:00

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

2008-11-24T18:50:00.000-08:00

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

2008-11-24T18:34:00.000-08:00

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

2008-11-24T18:31:00.000-08:00

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

2008-11-24T18:24:00.000-08:00

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

2008-11-24T18:17:00.001-08:00

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

2008-11-24T18:04:00.000-08:00

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

2008-11-24T17:56:00.000-08:00

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.

Our Visit to Mumbai

2008-11-23T07:38:00.000-08:00

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

2008-11-23T07:27:00.000-08:00

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.

Strip Attachement from Outlook

2008-11-16T03:09:00.000-08:00

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

2008-11-16T03:07:00.000-08:00

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

2008-11-16T03:04:00.000-08:00

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

Turn Off Display of Friendly Errors

2008-11-16T03:02:00.000-08:00

http://windowsxp.mvps.org/iefaq.htm http://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

2008-11-16T02:58:00.000-08:00

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

www.ncon.in/excel.htm

Nishith Desai

Diwali Puja in Office

2008-11-16T02:42:00.000-08:00

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

2008-11-16T00:20:00.000-08:00

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***************************************

2008-11-16T00:15:00.000-08:00

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

2008-11-16T00:05:00.000-08:00

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

Rajeev Birthday on 11.11.2008

2008-11-15T23:46:00.000-08:00

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

Removing quick info virus

2008-03-01T04:48:00.000-08:00

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