Thursday, October 3, 2013

ShutDown Machine through Command Prompt

To Shutdown machine using command prompt use the below Command:

Shutdown your Self Machine:

          shutdown -r(Restart) -t (time Sec) -f(Force) (Shutdown Self Machine)

Abort the command to Shutdown your Self Machine:

          shutdown -a (Abort Shutdown Command for self-Machine)


Shutdown the Remote Machine: 

         shutdown /m \\systemname -r(Restart) -t (time Sec) -f(Force) /c "Comment"


Abort the command to Shutdown Remote Machine: 

shutdown /m \\systemname -a (Abort Remote Machine)


Saturday, August 24, 2013

OWA 2010 Keyboard Shortcuts

Applies to:

Office 365 for professionals and small businesses, Office 365 for enterprises, Microsoft Exchange.

Calendar Keyboard shortcut Function
ENTER Opens the selected appointment or meeting.
DELETE Deletes the selected appointment or meeting. For repeating appointments or meetings, only the selected occurrence is deleted.
TAB Selects the next option, appointment, or meeting in the Day view.
SHIFT+TAB Selects the previous option, appointment, or meeting in the Day view.
   
Contacts  Keyboard shortcut Function
CTRL+S Saves changes to the open contact.
ENTER Opens the selected contact.
DELETE Deletes the selected contact.
UP ARROW Selects the previous contact in the list.
DOWN ARROW Selects the next contact in the list.
SHIFT+UP ARROW Selects the current and previous contacts in the list.
SHIFT+DOWN ARROW Selects the current and next contacts in the list.
HOME Selects the first contact in the list.
END Selects the last contact in the list.
PAGE UP For contact lists of two or more pages, selects the first contact on the previous page.
PAGE DOWN For contact lists of two or more pages, selects the first contact on the next page.
TAB Selects the next option in the Contacts view.
SHIFT+TAB Selects the previous option in the Contacts view.
   
Inbox and Other E-Mail Folder Keyboard shortcut Function
ENTER Opens the selected message.
CTRL+N Opens a new message form.
CTRL+Q Marks the selected message as Read.
To use this shortcut with Internet Explorer 7, you need to disable the Quick Tabs feature.
CTRL+R Replies to the selected message.
CTRL+SHIFT+R Replies to the sender and all recipients of the selected message.
CTRL+SHIFT+F Forwards the selected message.
DELETE Deletes the selected message.
SHIFT+DELETE Permanently deletes the selected message.
UP ARROW Selects the previous message in the list.
DOWN ARROW Selects the next message in the list.
SHIFT+UP ARROW Selects the current and previous messages in the list.
SHIFT+DOWN ARROW Selects the current and next messages in the list.
HOME Selects the first message in the list.
END Selects the last message in the list.
PAGE UP For message lists of two or more pages, selects the first message on the previous page.
PAGE DOWN For message lists of two or more pages, selects the first message on the next page.
TAB Selects the next option in the Inbox view.
SHIFT+TAB Selects the previous option in the Inbox view.
   
Options Keyboard shortcut Function
CTRL+S Saves changes to your Options.
TAB Selects the next option in the Options view.
SHIFT+TAB Selects the previous option in the Options view.
   
Tasks Keyboard shortcut Function
CTRL+S Saves changes to the open task.
ENTER Opens the selected task.
DELETE Deletes the selected task. For recurring tasks, the entire series is deleted.
SHIFT+DELETE Permanently deletes the selected task.
UP ARROW Selects the previous task in the list.
DOWN ARROW Selects the next task in the list.
SHIFT+UP ARROW Selects the current and previous tasks in the list.
SHIFT+DOWN ARROW Selects the current and next tasks in the list.
HOME Selects the first task in the list.
END Selects the last task in the list.
PAGE UP For task lists of two or more pages, selects the first task on the previous page.
PAGE DOWN For task lists of two or more pages, selects the first task on the next page.
TAB Selects the next option in the Tasks view.
SHIFT+TAB Selects the previous option in the Tasks view.
   
Message and Meeting Request Form Keyboard shortcut Function
ESC Closes the window.
CTRL+> or CTRL+period Views the next item in the list.
CTRL+< or CTRL+comma Views the previous item in the list.
CTRL+R Replies to the sender of the item.
CTRL+SHIFT+R Replies to everyone in the To and Cc boxes.
CTRL+SHIFT+F Forwards the item.
TAB Selects the next option on the message or meeting request form.
SHIFT+TAB Selects the previous option on the message or meeting request form.
CTRL+TAB Returns to the beginning of the tab sequence in the item. For example, in a meeting request, if an attendee's name is selected, pressing CTRL+TAB resets the focus so that pressing TAB selects Accept in the toolbar.
CTRL+D Permanently deletes the message or meeting request form.
   
New Appointment and Meeting Request Forms Keyboard shortcut Function
CTRL+S Saves the appointment or meeting request.
CTRL+D Permanently deletes the appointment or meeting request.
ALT+S Sends the meeting request.
CTRL+K or ALT+K Resolves the names in the address boxes.
   
New Message Form Keyboard shortcut Function
CTRL+S Saves the message to the Drafts folder.
CTRL+D Permanently deletes the message.
ALT+S Sends the message.
F7 Checks the spelling in the message.
CTRL+K or ALT+K Resolves the names in the address boxes.
ALT+T, ALT+C, or ALT+B Opens the Find Names dialog box.
   
Text Editing Keyboard shortcut Function
BACKSPACE Deletes the selection or the character to the left of the cursor.
CTRL+BACKSPACE Deletes the word to the left of the cursor but not the space before the word.
CTRL+C Copies the selection to the Clipboard.
CTRL+V Pastes the contents of the Clipboard into the current location.
CTRL+X Cuts the selection to the Clipboard.
DELETE Deletes the selection without copying it to the Clipboard.
INSERT Toggles between inserting and overwriting text.
CTRL+Z Reverses the effect of the most recent formatting command.
CTRL+Y Reapplies the most recent formatting command.
CTRL+F Finds text.
SHIFT+F10 Displays a menu of options, if one exists. This is the same as right-clicking an item or option in the text.
CTRL+L Displays the Hyperlink dialog box. This lets you insert or change a hyperlink in the text.
   
Checking Spelling Keyboard shortcut Function
F7 Checks the spelling in the message.
CTRL+J Jumps to the next misspelled word after the pointer and opens the Suggestions menu.
  When the Suggestions menu is open:
UP ARROW Moves up through the list.
DOWN ARROW Moves down through the list.
RIGHT ARROW Puts the pointer at the end of the misspelled word.
LEFT ARROW Puts the pointer at the beginning of the misspelled word.
ESC Hides the menu and puts the pointer at the beginning of the misspelled word.
ENTER Selects a highlighted item in the menu.
   
Text Formatting Keyboard shortcut  Function
CTRL+B Toggles bold formatting.
CTRL+I Toggles italic formatting.
CTRL+U Toggles underlining.
   
Right-to-Left Layout Keyboard shortcut Function
CTRL+LEFT SHIFT Sets the message area for left-to-right typing and editing. This is the orientation for most Western languages.
CTRL+RIGHT SHIFT Sets the message area for right-to-left typing and editing. This is the orientation for languages such as Arabic and Hebrew. When you press CTRL+RIGHT SHIFT, the scroll bar moves to the left edge of the message window.

Open multiple user mailboxes in OWA 2010

 In OWA 2010, it’s impossible to open multiple user mailboxes. 

OWA 2010 will allow for only one user at a time per session. No matter what you use new  tabs, new windows – you get an error message:

“You may have already opened your mailbox on a different browser tab. If you feel you've received this message in error, try refreshing your browser.”

To open multiple mailbox then on the browser click File> New Session. 

Since most of the users use desktop shortcuts or predefined urls in the favorites tab, the smarter solution would be to create these shortcuts with the following argument:

"C:\Program Files\Internet Explorer\iexplore.exe" -noframemerging https://Webmail Address>/owa/<user's email address>

This will allow you to open multiple windows with multiple users mailbox.

Unfortunatelly, it does not work in tabbed browsing.

Saturday, March 2, 2013

UnProtect / Remove Password from Protected Excel Worksheet

Open the password protected Excel Worksheet then 
  1. Go to View > Macros.
  2. Click on Record Macros > Ok.
  3. Then go to View > Macro again and click Stop Record > Ok.
  4. Then click on View Macros under View > Macro.
  5. You will find a Macro with a default name Macro1.
  6. Select the Default Macro > Edit.
  7. A Visual Basic Editor will open 
  8. Replace the Default Code with the code mentioned Below.
Sub Macro1()
'
Const DBLSPACE As String = vbNewLine & vbNewLine

Const AUTHORS As String = DBLSPACE & vbNewLine & "Adapted from Bob McCormick base code by" & "Prakhar http://http://comtechsolution.blogspot.com/"

Const HEADER As String = "AllInternalPasswords User Message"

Const VERSION As String = DBLSPACE & "Version 1.0 8 Mar 2013"

Const REPBACK As String = DBLSPACE & "Please report failure to prakharclall@gmail.com "

Const ALLCLEAR As String = DBLSPACE & "The workbook should be cleared"

Const MSGNOPWORDS1 As String = "There were no passwords on " & AUTHORS & VERSION

Const MSGNOPWORDS2 As String = "There was no protection to " & "workbook structure or windows." & DBLSPACE


Const MSGTAKETIME As String = "After pressing OK button this " & "will take some time." & DBLSPACE & "Amount of time " & "depends on how many different passwords, the "



Const MSGPWORDFOUND1 As String = "You had a Worksheet " & "Structure or Windows Password set." & DBLSPACE & "The password found was: " & DBLSPACE & "$$" & DBLSPACE & "Note it down for potential future use in other workbooks by " & "the same person who set this password." & DBLSPACE & "Now to check and clear other passwords." & AUTHORS & VERSION

Const MSGPWORDFOUND2 As String = "You had a Worksheet " & "password set." & DBLSPACE & "The password found was: " & DBLSPACE & "$$" & DBLSPACE & "Note it down for potential " & "future use in other workbooks by same person who " & "set this password." & DBLSPACE & "Now to check and clear " & "other passwords." & AUTHORS & VERSION

Const MSGONLYONE As String = "Only structure / windows " & "protected with the password that was just found." & ALLCLEAR & AUTHORS & VERSION & REPBACK

Dim w1 As Worksheet, w2 As Worksheet

Dim i As Integer, j As Integer, k As Integer, l As Integer

Dim m As Integer, n As Integer, i1 As Integer, i2 As Integer

Dim i3 As Integer, i4 As Integer, i5 As Integer, i6 As Integer

Dim PWord1 As String

Dim ShTag As Boolean, WinTag As Boolean

Application.ScreenUpdating = False

With ActiveWorkbook

WinTag = .ProtectStructure Or .ProtectWindows

End With

ShTag = False

For Each w1 In Worksheets

ShTag = ShTag Or w1.ProtectContents

Next w1

If Not ShTag And Not WinTag Then

MsgBox MSGNOPWORDS1, vbInformation, HEADER

Exit Sub

End If

MsgBox MSGTAKETIME, vbInformation, HEADER

If Not WinTag Then

MsgBox MSGNOPWORDS2, vbInformation, HEADER

Else

On Error Resume Next

Do 'dummy do loop

For i = 65 To 66: For j = 65 To 66: For k = 65 To 66

For l = 65 To 66: For m = 65 To 66: For i1 = 65 To 66

For i2 = 65 To 66: For i3 = 65 To 66: For i4 = 65 To 66

For i5 = 65 To 66: For i6 = 65 To 66: For n = 32 To 126

With ActiveWorkbook

.Unprotect Chr(i) & Chr(j) & Chr(k) & Chr(l) & Chr(m) & Chr(i1) & Chr(i2) & Chr(i3) & Chr(i4) & Chr(i5) & Chr(i6) & Chr(n)

If .ProtectStructure = False And .ProtectWindows = False Then

PWord1 = Chr(i) & Chr(j) & Chr(k) & Chr(l) & Chr(m) & Chr(i1) & Chr(i2) & Chr(i3) & Chr(i4) & Chr(i5) & Chr(i6) & Chr(n)

MsgBox Application.Substitute(MSGPWORDFOUND1, "$$", PWord1), vbInformation, HEADER

Exit Do 'Bypass all for...nexts

End If

End With

Next: Next: Next: Next: Next: Next

Next: Next: Next: Next: Next: Next

Loop Until True

On Error GoTo 0

End If

If WinTag And Not ShTag Then

MsgBox MSGONLYONE, vbInformation, HEADER

Exit Sub

End If

On Error Resume Next

For Each w1 In Worksheets

'Attempt clearance with PWord1

w1.Unprotect PWord1

Next w1

On Error GoTo 0

ShTag = False

For Each w1 In Worksheets

'Checks for all clear ShTag triggered to 1 if not.

ShTag = ShTag Or w1.ProtectContents

Next w1

If ShTag Then

For Each w1 In Worksheets

With w1

If .ProtectContents Then

On Error Resume Next

Do 'Dummy do loop

For i = 65 To 66: For j = 65 To 66: For k = 65 To 66

For l = 65 To 66: For m = 65 To 66: For i1 = 65 To 66

For i2 = 65 To 66: For i3 = 65 To 66: For i4 = 65 To 66

For i5 = 65 To 66: For i6 = 65 To 66: For n = 32 To 126

.Unprotect Chr(i) & Chr(j) & Chr(k) & Chr(l) & Chr(m) & Chr(i1) & Chr(i2) & Chr(i3) & Chr(i4) & Chr(i5) & Chr(i6) & Chr(n)

If Not .ProtectContents Then

PWord1 = Chr(i) & Chr(j) & Chr(k) & Chr(l) & Chr(m) & Chr(i1) & Chr(i2) & Chr(i3) & Chr(i4) & Chr(i5) & Chr(i6) & Chr(n)

MsgBox Application.Substitute(MSGPWORDFOUND2, "$$", PWord1), vbInformation, HEADER

'leverage finding Pword by trying on other sheets

For Each w2 In Worksheets

w2.Unprotect PWord1

Next w2

Exit Do 'Bypass all for...nexts

End If

Next: Next: Next: Next: Next: Next

Next: Next: Next: Next: Next: Next

Loop Until True

On Error GoTo 0

End If

End With

Next w1

End If

MsgBox ALLCLEAR & AUTHORS & VERSION & REPBACK, vbInformation, HEADER
'
End Sub

9. Now Run the Macro and you will get the password of the  
   protected Excel Worksheet.





Thursday, January 31, 2013

Attach Picture in Body of mail in OWA or Webmail

1.   Open Webmail.
2.       Select Option > scroll down to “Privacy and Junk E-mail Prevention” > Uncheck  “Block external content in HTML e-mail messages.”
3.       Now click to compose New Mail > Click on Clip Icon to attach.
4.       Browse the saved image file and click on Attach> Do not  click Done > Double click on the attached Image in the Attachment box it will open in IE then Right click on the Image open in browser  select Copy and then Paste it in body of the using Key Ctrl + V.
5.       Repeat step 5 to attach multiple image.
6.       Send the mail.
It is done ....

Thursday, January 17, 2013

How to use Windows Notepad as a Diary

Notepad can also be used a digital diary for maintaining time schedules or other activities.

1. Open up a blank Notepad file (Name the .txt document whatever you want.)

2. Write .LOG (Case sensitive) as the first line of the file, Hit Enter enter,Then Save the file 
     and close it.     Note: You must type .LOG in capital letters!

3. Re-Open the Saved file and see you will see that Notepad adds the current date and 
     current time

4. Type your notes and then save and close the file.

5. Each time you open the file,Windows Notepad will repeat the process.

Now write your daily/hourly activities easily. To bring the current date and time just press F5!

Monday, December 17, 2012

Keyboard Shortcuts


Keyboard Shortcuts (Microsoft Windows)

1. CTRL+C : (Copy)
2. CTRL+X : (Cut)
3. CTRL+V : (Paste)
4. CTRL+Z  : (Undo)
5. DELETE : (Delete)
6. SHIFT+DELETE : (Delete the selected item permanently without placing the item in the
                                     Recycle Bin)
7. CTRL while dragging an item (Copy the selected item)
8. CTRL+SHIFT while dragging an item (Create a shortcut to the selected item)
9. CTRL+RIGHT ARROW  (Move the insertion point to the beginning of the next word)
10. CTRL+LEFT ARROW (Move the insertion point to the beginning of the previous word)
11. CTRL+DOWN ARROW (Move the insertion point to the beginning of the next paragraph)
12. CTRL+UP ARROW (Move the insertion point to the beginning of the previous paragraph)
13. CTRL+SHIFT with any of the arrow keys (Highlight a block of text)
14. CTRL+A (Select all)
15. ALT+ENTER (View the properties for the selected item)
16. ALT+F4 (Close the active item, or quit the active program)
17. ALT+ENTER (Display the properties of the selected object)
18. ALT+SPACEBAR (Open the shortcut menu for the active window)
19. CTRL+F4 (Close the active document in programs that enable you to have multiple
                           documents open simultaneously)
20. ALT+TAB (Switch between the open items)
21. ALT+ESC (Cycle through items in the order that they had been opened)
22. SHIFT+F10 (Display the shortcut menu for the selected item)
23. ALT+SPACEBAR (Display the System menu for the active window)
24. CTRL+ESC (Display the Start menu)
25. ALT+Underlined letter in a menu name (Display the corresponding menu) Underlined letter
                                     in a command name on an open menu (Perform the corresponding
                                     command)
26. RIGHT ARROW (Open the next menu to the right, or open a sub menu)
27. LEFT ARROW (Open the next menu to the left, or close a sub menu)
28. BACKSPACE (View the folder one level up in My Computer or Windows Explorer)
29. ESC (Cancel the current task)
30. SHIFT when you insert a CD-ROM into the CD-ROM drive (Prevent the CD-ROM from
                                                                                                           automatically playing)
31. F2 key  (Rename the selected item)
32. F3 key (Search for a file or a folder)
33. F6 key (Cycle through the screen elements in a window or on the desktop)
34. F4 key (Display the Address bar list in My Computer or Windows Explorer)
35. F10 key (Activate the menu bar in the active program)
36. F5 key (Update the active window)



Dialog Box - Keyboard Shortcuts

1. CTRL+TAB (Move forward through the tabs)
2. CTRL+SHIFT+TAB (Move backward through the tabs)
3. TAB (Move forward through the options)
4. SHIFT+TAB (Move backward through the options)
5. ALT+ Underlined letter (Perform the corresponding command or select the corresponding
                                                option)
6. ENTER (Perform the command for the active option or button)
7. SPACEBAR (Select or clear the check box if the active option is a check box)
8. Arrow keys (Select a button if the active option is a group of option buttons)
9. F1 key (Display Help)
10. F4 key (Display the items in the active list)
11. BACKSPACE (Open a folder one level up if a folder is selected in the Save As or Open
                                  dialog box)

Microsoft Natural Keyboard Shortcuts

1. Windows Logo (Display or hide the Start menu)
2. Windows Logo + BREAK (Display the System Properties dialog box)
3. Windows Logo + D (Display the desktop)
4. Windows Logo + M (Minimize all of the windows)
5. Windows Logo + SHIFT+M (Restore the minimized windows)
6. Windows Logo + E (Open My Computer)
7. Windows Logo + F (Search for a file or a folder)
8. CTRL + Windows Logo + F (Search for computers)
9. Windows Logo + F1 (Display Windows Help)
10. Windows Logo+ L (Lock the keyboard)
11. Windows Logo + R (Open the Run dialog box)
12. Windows Logo + U (Open Utility Manager)

Accessibility Keyboard Shortcuts

1. Right SHIFT for eight seconds (Switch Filter Keys either on or off)
2. Left ALT + Left SHIFT+PRINT SCREEN (Switch High Contrast either on or off)
3. Left ALT + Left SHIFT+NUM LOCK (Switch the Mouse Keys either on or off)
4. SHIFT five times (Switch the Sticky Keys either on or off)
5. NUM LOCK for five seconds (Switch the Toggle Keys either on or off)
6. Windows Logo + U (Open Utility Manager)

Windows Explorer Keyboard Shortcuts

1. END (Display the bottom of the active window)
2. HOME (Display the top of the active window)
3. NUM LOCK+ Asterisk sign (*) (Display all of the sub-folders that are under the selected
                                                                   folder)
4. NUM LOCK + Plus sign (+) (Display the contents of the selected folder)
5. NUM LOCK + Minus sign (-) (Collapse the selected folder)
6. LEFT ARROW (Collapse the current selection if it is expanded, or select the parent folder)
7. RIGHT ARROW (Display the current selection if it is collapsed, or select the first subfolder)

Shortcut Keys for Character Map

After you double-click a character on the grid of characters, you can move through the grid by using the keyboard shortcuts:

1. RIGHT ARROW (Move to the right or to the beginning of the next line)
2. LEFT ARROW (Move to the left or to the end of the previous line)
3. UP ARROW (Move up one row)
4. DOWN ARROW (Move down one row)
5. PAGE UP (Move up one screen at a time)
6. PAGE DOWN (Move down one screen at a time)
7. HOME (Move to the beginning of the line)
8. END (Move to the end of the line)
9. CTRL+HOME (Move to the first character)
10. CTRL+END (Move to the last character)
11. SPACEBAR (Switch between Enlarged and Normal mode when a character is selected)

Microsoft Management Console (MMC)

Main Window Keyboard Shortcuts

1. CTRL+O (Open a saved console)
2. CTRL+N (Open a new console)
3. CTRL+S (Save the open console)
4. CTRL+M (Add or remove a console item)
5. CTRL+W (Open a new window)
6. F5 key (Update the content of all console windows)
7. ALT+SPACEBAR (Display the MMC window menu)
8. ALT+F4 (Close the console)
9. ALT+A (Display the Action menu)
10. ALT+V (Display the View menu)
11. ALT+F (Display the File menu)
12. ALT+O (Display the Favorites menu)
13. CTRL+P (Print the current page or active pane)
14. ALT + Minus sign (-) (Display the window menu for the active console window)
15. SHIFT+F10 (Display the Action shortcut menu for the selected item)
16. F1 key (Open the Help topic, if any, for the selected item)
17. F5 key (Update the content of all console windows)
18. CTRL+F10 (Maximize the active console window)
19. CTRL+F5 (Restore the active console window)
20. ALT+ENTER (Display the Properties dialog box, if any, for the selected item)
21. F2 key (Rename the selected item)
22. CTRL+F4 (Close the active console window. When a console has only one console window,
                           this shortcut closes the console)

Remote Desktop Connection Navigation

1. CTRL+ALT+END (Open the Microsoft Windows NT Security dialog box)
2. ALT+PAGE UP (Switch between programs from left to right)
3. ALT+PAGE DOWN (Switch between programs from right to left)
4. ALT+INSERT (Cycle through the programs in most recently used order)
5. ALT+HOME (Display the Start menu)
6. CTRL+ALT+BREAK (Switch the client computer between a window and a full screen)
7. ALT+DELETE (Display the Windows menu)
8. CTRL + ALT + Minus sign (-) (Place a snapshot of the active window in the client on the
                                                          Terminal server clipboard and provide the same
                                                          Functionality as pressing PRINT SCREEN on a local
                                                          computer.)
9. CTRL + ALT+ Plus sign (+) (Place a snapshot of the entire client window area on the
                                                      Terminal server clipboard and provides the same functionality
                                                      as pressing ALT+PRINT SCREEN on a local computer.)

Microsoft Internet Explorer Keyboard Shortcuts

1. CTRL+B (Open the Organize Favorites dialog box)
2. CTRL+E (Open the Search bar)
3. CTRL+F (Start the Find utility)
4. CTRL+H (Open the History bar)
5. CTRL+I (Open the Favorites bar)
6. CTRL+L (Open the Open dialog box)
7. CTRL+N (Start another instance of the browser with the same Web address)
8. CTRL+O (Open the Open dialog box, the same as CTRL+L)
9. CTRL+P (Open the Print dialog box)
10. CTRL+R (Update the current Web )