How To: Automate MS Excel
Author
: Sunny Yadav
Blog
: Sunny Yadav's Blog
Date
: 10/17/2012 4:59:00 PM
'MS Excel, sometimes we got some task which is time taking and require good manual effort. To automate these kind of task and making our life easy there are two ways -1) Macro - MS Excel provide Macros functionality to automate tasks in Excel. We can record our steps ( go to 'View' tab then Record Macro) then run this recorded Macro to perform the same task again. It will be good if you know VB Scripting to write general algorithm Macros.2) Python - Python has excel API xlrd and xlwt(...)'
Read full article
How to: Maintain your privacy online
Author
: Sunny Yadav
Blog
: Sunny Yadav's Blog
Date
: 4/25/2012 5:13:00 PM
'In today's time if we are using Internet that means we are using Facebook, Twitter, Google+ websites more frequently to stay online and stay connected with our friends. Of-course these sites are the best way to share our thoughts to our friends in a fast way but Beware!!! they are watching our every activity online.Surprise!! , lets begin from starting; Today everybody wants to be social on Internet, so to fulfill this every website becoming social by using social plugins (...)'
Read full article
How to host a non - commercial firewall
Author
: Sunny Yadav
Blog
: Sunny Yadav's Blog
Date
: 2/9/2012 6:12:00 PM
'Firewall is very important part of the network security, so if you looking for a non - commercial firewall there is an open source SmoothWall is there to increase your home or office security.The installation of SmoothWall is very easy and it is very easy to use also. For installation take any old system (means minimum hardware requirement) who having two NIC cards for configuring the NAT, one NIC for your public network and other one for your private network.The installation of Smo(...)'
Read full article
How to host DC hub
Author
: Sunny Yadav
Blog
: Sunny Yadav's Blog
Date
: 1/28/2012 2:56:00 PM
'A DC(Direct Connect) hub is a common sharing platform to share files (audio/video/documents etc.). So , to host DC hubIn Ubuntu :$ sudo apt-get install opendchubAfter installing opendchub$ sudo opendchubThen it will ask you for port number on which DC hub will listen for user connections , so provide a port number (eg. 789 or 20103) then it will ask you for a admin link password and hub link password , so provide both passwords. Now you successfully configured the DC hub, so st(...)'
Read full article
How To: Convert .doc file to .pdf file
Author
: Sunny Yadav
Blog
: Sunny Yadav's Blog
Date
: 9/20/2011 4:17:00 PM
'In day to day life every man has some documents which he wants to share public with some security like printing is allowed or not, data extraction is allowed or not , etc. for this type of securities issue pdf is best.To convert .doc file (MS Word file) to .pdf file there are two simple methods: 1. SaveAsPdfandXPS : It is a Microsoft 'Add-in' in MS Word to save as word document file directly to pdf or xps. It is a exe file so you can easily install it by double clicking the file.Yo(...)'
Read full article