Search Windows and Linux Networking

Wednesday, May 18, 2011

Create your own Library for Script


Create your own Library for Script

It is better to use our existing script that we have already created for some task. To avid to rewrite same code for same task in our new script just create your own library and just point the old script file for do specific task. I will show, how to create library and how to use it.

Open the command prompt and go to D drive with D:

Now create some folder hierarchy for our library

mkdir Scripts
cd Scripts
mkdir Includes
mkdir GroupScripts
mkdir UserScripts

Now Create simple “hello word “  VBScript file in D:\Scripts\Includes folder as “hello.vbs” for reference

Open notepad and type simple line

MsgBox “hello word”

And save file as “hello.vbs” in includes folder.

Now, we actually create Script file that we are actually going to execute.

Open notepad and type

<job>
<Script language="VBScript"src="Includes\test.vbs" />
<script language=VBScript >
Wscript.Echo "test"
</script>
</job>

And save the file as “sample.wsf” in main script folder D:\Scripts

Now execute the file sample.wsf . when it run. It do some task given in reference file for our example it take reference for hello.vbs and the do other task from main script. That’s it.

Monday, May 16, 2011

VLookup function in MS-Excel


VLookup function in MS-Excel


Today I learn very interesting and very useful function in excel that is vlookup. It save my loot of time for updating file.

I got one excel fine from sir that was contain users in fist Column and they was wanted other information for that user. (immediately) that file canton more than 300 users. I was already all users data but they  wanted only that users information not other.  So, I was trying to search for function that find value in other file and if the value found then pest value next to other column. But unsuccessful then sir show me very interacting function in excel that save my time vlookup.


And I think it also help many users that’s why I think to post this. See the Find the link step by step instruction about how to use vlookup in excel  :-