Wednesday, May 2, 2012

how to take excle file backup automatically and put password on excel file

Automatic Backup (.XLK) when File is Saved (#auto)

Setting up for automatic backup of a file.  (on a single file basis, not global)
  • Save the file
  • Save As (F12 key), then on the Save As Dialog menus: Tools --> General Options, check “Always create backup copy”.  Answer “Yes” when prompted to replace the old document.  Your new document is identical except that the new one saves a backup each time you save the file.
Now, as to the backups: they are always one save behind the original document.  Excel backups have the original name and the suffix .xlk (with a displayed filetype of “Microsoft Excel Backup File”), and will appear in the same folder as the original.  With the Excel backup you can use Autosave and backup simultaneously. 

Tuesday, May 1, 2012

What is the difference between bridged, NAT and host-only networking? Which should I use?

A virtual machine in VMware Server, Workstation and Player can have virtual network cards that are "bridged", "NAT" or "host-only".
In Linux, a network of each type is created when running vmware-config.pl. In Windows, they are automatically created. If you didn't create them the first time vmware-config.pl was run, you can re-run it.
Comparison of the network types
Type Bridged NAT
(Network Address Translation)

Host-only
Description The VM appears as if it was
a physical host on the network.
The VM hides behind the IP address of the VMware host. Other VMs in the same NAT network can access it directly. The VM can only access the VMware host and other VMs in the same host-only network
IP address The VM requires it's own IP address from the network it is supposed to  belong to.
The VM can have any private IP configured on the VMware host. 
Accessibility from network Same as a physical host Hides behind NAT, so port forwarding on the VMware host required if external access required Not accessible from external network unless routed via another VM with access to both external network and the same host-only network
Use cases  An always-on server hosted on VMware, or a virtual router or firewall  VMs intended for testing, or cases when the amount of IP addresses in the external network is limited. VMs intended for testing with no need to access the network, or VMs which will be protected by a firewall in another VM.
Other Known to have problems with some wireless chipsets especially with Linux, also with Windows Vista. NAT is really a host-only network with a default gateway (on the VMware host) that routes and NATs.  

Thursday, December 8, 2011

IMAP vs. POP

What do they stand for?

IMAP
Internet Message Access Protocol
POP
Post Office Protocol

What's the difference?

The main difference, as far as we are concerned here, is the way in which IMAP or POP controls your e-mail inbox.
When you use IMAP you are accessing your inbox on the U of M's central mail server. IMAP does not actually move messages onto your computer. You can think of an e-mail program using IMAP as a window to your messages on the server. Although the messages appear on your computer while you work with them, they remain on the central mail server.
POP does the opposite. Instead of just showing you what is in your inbox on the U's mail server, it checks the server for new messages, downloads all the new messages in your inbox onto your computer, and then deletes them from the server. This means that every time you use POP to view your new messages, they are no longer on the central mail server. Figure 1 illustrates these concepts.

IMAP

IMAP client-server diagram, both clients see same inbox

POP

POP client-server diagram, office computer retrieves new mail, home computer then sees none
Figure 1: Accessing your inbox, IMAP versus POP.

IMAP makes it easier to view mail from home, work, and other locations

Because IMAP leaves all of your messages on the central mail server, you can view these messages from any location with Internet access. This means the U of M e-mail inbox you view from home will be the same one you see at work.
Since POP downloads new messages to your computer and removes them from the server, you will not be able to see those new messages on another computer when you check your inbox. Those messages exist only on the computer that downloaded them using POP.
However, if you use IMAP and create e-mail folders on the server, these folders are accessible from anywhere you read your e-mail using IMAP. If you use POP and create e-mail folders, they are stored locally, and you cannot access these folders from anywhere except the computer on which you created them.
POP can create problems if you alternate between it and IMAP. There is an option in many POP e-mail programs to leave copies of the messages on the server, but this option has complications. When you leave copies of the messages on the server, then access your e-mail using WebMail or another IMAP e-mail client, the POP client may create duplicate messages next time it accesses the inbox; you will see each of the messages more than once, and you will have to clean out (delete) the unwanted ones.

You may want to keep local copies

While using IMAP to save e-mail on the central mail server is recommended, there are reasons to have local copies of messages (messages downloaded to the computer, as with POP). Fortuanately, IMAP allows you to keep local copies of all your messages. The option of local copies is useful when you are connecting from a dial-up connection. You may want to download your messages, then disconnect from the Internet and work with your mail offline. Please note that while you are working offline, you cannot send or receive mail. You need to be connected to the Internet to do those tasks.

You have a backup of your e-mail with IMAP

The University's central e-mail servers are backed up every night. Thus, when your e-mail is stored on the U's e-mail server (as is the case with IMAP), a backup of your e-mail is made every night. These backups are used in the event of system failures or if a virus deletes your local mail. If you use POP, you lose your mail. The University cannot help you recover it because it was not stored the U's central e-mail server.
With the growing number of computer viruses and attacks from hackers, there is a greater possibility that e-mail can be deleted without your knowledge. The best insurance against loss of important e-mail is to have it on the University's e-mail server.

How To Configure GMail Account With Microsoft Outlook 2010

Microsoft Outlook is the most powerful and intuitive e-mail client software. Microsoft’s Outlook 2010 provides  a very rich set of e-mail management tools to help you better manage your emails with a cool user interface. If you have a GMail account, then configuring the account with Microsoft Outlook 2010 is a piece-of-cake.

First of all launch MS Outlook 2010 and click the office button which is located in the left most corner, now under the Info category you will be able to see the Account Settings option, click the drop down button and choose Add Account as shown in following screenshot.
create-new-account-outlook-2010
In the next step, select Email Account, enter Your Name, Email Address, and Password and click Next.
auto-account-setup11
Now sit back and relax, Outlook 2010 will do the rest for you, it will establish connection to the relevant network, search for GMail server settings and log you on to the server automatically.
outlook-accountsetup-2
It will take a couple of minutes to complete the required configuration.
outlook-2010-gmail-complete
Click Finish and thats all, it will take some time to download your emails.
gmail-configured-with-outlook1
Now use all the enhanced features of Outlook 2010 to manage your GMail inbox. Enjoy!

How to configure gmail account on outlook 2007

Step1: Configure Gmail Account
  • First Log into your gmail account.
  • Left-click "Settings" in the upper right corner of the gmail page.
  • In "Settings," click the "Forwarding and POP/IMAP" tab.
  • Locate the "IMAP Access" section. Click the "Enable IMAP" radio button.
  • Click "Save Changes." Your gmail account is now ready to be configured in Outlook 2007.
Step2 : Configure outlook 2007
  • In Outlook 2007, click "Tools" on the main toolbar. In the drop-down menu, Click "Account Settings." In the account settings dialog box, the "Email" tab is selected by default.
  • With the "Email" tab selected, click "New." The "Add New E-mail Account" dialog box will appear. In the form provided, enter your name, email address and password. Click the box next to "Manually configure server settings or additional server types," then click "Next."
  • In the "Choose E-mail Service" dialog box, click the radio button next to "Internet E-Mail." Click "Next" to progress to the "Internet E-mail Settings" option.
  • In the "Server Information" section, click the arrow next to account type and select IMAP. In the "Incoming Mail Server" box type "imap.gmail.com". In the "Outgoing Mail Server" box type "smtp.gmail.com".
  • In the "Logon Information" section, insert your full Gmail address in the "User Name" box. It should resemble "username@gmail.com." Insert your password in the "Password" box. Click the check box for "Remember Password," then lick "More Settings."
  • Click the "Advanced" tab. Change the "Incoming server (IMAP)" to "993" and select "SSL" from the drop-down menu. Set "Outgoing server (SMTP)" to "587" and select "TSL" from the drop-down menu.
  • Click the "Outgoing Server" tab. Click the check box and enable "My outgoing server (SMTP) requires authentication." Leave the radio button on "Use same settings as my incoming mail server." Click "OK."
  • On the "Internet E-mail Settings" dialog box, click "Next," then "Finish."
  • On the "Account Settings" dialog box, you will see your new Gmail account. Click "Close." If asked, you can instruct Outlook to synchronize your folders, or you can manually select "Send/Receive" on the top toolbar.

Thursday, September 15, 2011

How to remove rememberd password in shearing server on window

This command is useful to remove the add user and their password on any shearing server(samba). Using this command you can also add user and user password on any shearing server.
rundll32.exe keymgr.dll, KRShowKeyMgr
copy this command and past on command prompt.

Wednesday, September 14, 2011

Security cameras and multimedia streaming are affecting your network

There was a time when security cameras were hardwired back to a central location with lots of screens. Here people sat and watched and made sure that tapes of footage were changed and properly stored. In today's world, these devices are now IP-based and share computer networks with everything else.
I was visiting one of the largest football stadiums in Europe a few weeks back. The network manager gave me a very interesting tour, which focused on the IT infrastructure. Systems such as security cameras, crowd control monitoring, public announcement systems and the large screens around the arena are all now connected to a shared computer network.  This gives greater flexibility when deploying these systems as you don't need to run separate cables. However, it does create challenges for the IT manager as this data is now carried on their network.
This type of network traffic is not limited to places like arenas with lots of TV screens. While reviewing traffic rates on a university network recently, I found that over 75% of all traffic was associated with IP-based security cameras. They had a flat network with a single VLAN so it was becoming a big problem.
If you want to check for this activity on your network, I suggest you should be familiar with layers 2 and 3 of the OSI model. Over on the EtherGeek blog, Josh Stephens has some useful information on understanding layer 2 of the OSI model and understanding layer 3 of the OSI model.
In most cases, systems which generate audio or video outputs will stream this data onto a network using one of these methods.
  • Multicast traffic. IP multicast is typically used for sending IP datagram's to a group of interested receivers in a single transmission
  • User Datagram Protocol (UDP) traffic with specific source and destination IP addresses.
For those of you considering rolling out systems like IP-based security cameras or multimedia screens which get updates from the network, I would recommend that you create a specific VLAN for this traffic. This will keep it separate from other business critical applications.
I would also suggest that you check for this activity on your network. You can either do a periodic audit or have a system in place that constantly checks your network. There are two things to watch out for:
  1. Monitor traffic as it goes through the core of your network. You are looking for UDP activity. Normally applications which use TCP are the most active. If you find lots of UDP traffic, look at the source and destination IP addresses. If these are associated with media streaming then it could be time to consider moving this to a separate VLAN.
  2. Check for multicast activity. If your traffic analysis system allows you to use filters, check for activity associated with the 224.0.0.0/4 network. This block of IP addresses has been reserved for multicast. If you also use IPv6, then you should also check for activity associated with the ff00::/8 prefix.  
Finally, IPTV services are also getting popular. An IPTV is a service through which Internet television is delivered to end-users. The number of global IPTV subscribers is expected to grow significantly over the next few years. I will also deal with this topic in more detail in an upcoming post. In the meantime, you should keep an eye on any unusual activity on your Internet gateway which is using lots of bandwidth over long time periods. This can be a sign of large downloads or constant streaming media coming into your network.