Sunday, April 13, 2008

How to Change MAC Address

This is Very Simple and no need to install Software. Just Follow the Steps.

(For Win XP , Not Sure for Other Opearation System)

1. Go to Network Connection.
2. Opne Eatnernet Card Properties.
3. Click on "Configure" Button in "General".
4. Click on "Advanced".
5. Click on "Netword Address" from "Property" List.
6. Now Enter New MAC Address in "Value" Text Box Near "Property" list.

MAC Address is Changed.

Check MAC Address.

1. Open Command Prompt (DOS).
2. Type 'ipconfig /all' then press Enter.
3. You can See MAC Address is Changed.


Any Other Query You Can Mail Me :- a.suchariya@gmail.com

Tuesday, February 5, 2008

Can we give the output of a cell in another Excel File in Network ???

Yes , that is done by giving the address of source excel file in the destination file , as following:

e.g.

='\\192.168.0.1\Software (D)\[book1.xls]abc1'!$A$1

Here
“\\192.168.0.1” is the Another Computer IP Address.
“\Software (D)” is the D Driver of the H.D.D. .
“\[book1.xls]” is the file name.
”abc1” is the name of the Sheet name of Source File.
“$A$1” A is the Column Address & 1 is the Row Address.

Advantage

We can give the Network path also in the Excel Cell.
We can give more than one address in a single file from different files.

Disadvantage

It is Possible that the Cell Value can not Update when Destination file is open.


Any Other Query You Can Mail Me :- a.suchariya@gmail.com