Help Needed only Expert

**kamibest** · 30th June 2009, 12:14 PM

Aik Choti Si problem Ye hai Office Mai Kuch Scanning Documents hai 10000 above hai mai chahta ho un Sab ke Link Excel mai Convert hoo Sake

Or jab Kisi Link Per Click Karo to Wo Scan kiya Ho Doc Show Hojay

**Mubashir Aziz** · 2nd July 2009, 10:46 AM

Ofcourse its very easy...

1. in Excel Insert tool bar say select karain
2. Phie iss may Hyperlink
3. aap kay samnay aik widnows aa jay gi aab jiss document ko link karna hay ussay select kar lain
4. Same window main ooper wali bar main Text to Display: main aap issay koi naam bhi day saktay hain yaa phir poura path likha nazar aay ga (aap donoon ko try keejiye ga)
5. Ok kar dain
Aap kay pass link bun jay ga agar koi naam diya hay to naam likha aay ga agar text to display: ko blank rakha hay to pura path aay ga. Aap iss par click karain gay to woh document open ho jay ga .......

**kamibest** · 5th July 2009, 11:09 PM

mubsahir aziz said:

Ofcourse its very easy...

1. in Excel Insert tool bar say select karain
2. Phie iss may Hyperlink
3. aap kay samnay aik widnows aa jay gi aab jiss document ko link karna hay ussay select kar lain
4. Same window main ooper wali bar main Text to Display: main aap issay koi naam bhi day saktay hain yaa phir poura path likha nazar aay ga (aap donoon ko try keejiye ga)
5. Ok kar dain
Aap kay pass link bun jay ga agar koi naam diya hay to naam likha aay ga agar text to display: ko blank rakha hay to pura path aay ga. Aap iss par click karain gay to woh document open ho jay ga .......

Confusing Hai

10000 Snaps Ke Alag Alag Hyperlink Kese Banao Ga

Please reply

**Mubashir Aziz** · 6th July 2009, 09:00 AM

aap kay pass list of files hain jaisa ka iss thread main aap nay use kia tha ...

http://itdunya.com/showthread.php?t=88401&page=2

aab aap meri iss file ko daikhain and seconds main hyper link bana lain ......

main nay hyperlink() ka function use kia hay .......

**saqib2pk** · 6th July 2009, 09:21 AM

aoa bhai sub ko select karo and past in to excel sheet it take time lakin sub ho jain gi inshallah

**kamibest** · 6th July 2009, 02:03 PM

mubsahir aziz said:

aap kay pass list of files hain jaisa ka iss thread main aap nay use kia tha ...

http://itdunya.com/showthread.php?t=88401&page=2

aab aap meri iss file ko daikhain and seconds main hyper link bana lain ......

main nay hyperlink() ka function use kia hay .......

Thori Si Confusing hai
ye Dekhe Snaps mai Sab ko ALag Alag karna Pare Ga All Select nahi Horahi Hai

Ap maire ko Hosake to Screen Shot Ki madad se batade

**Mubashir Aziz** · 6th July 2009, 02:15 PM

Naheen Bhai aap mairi new file jo main nay post # 4 main share key open karain aur check karain ....main nay uss main hyperlink() cells par use kia hay ......
Jaisa kay aap nay bataya tha ka aap file list aik software key help say excel main extract kar laitay hain .... tou aap nay woh list excel main extract kara kay aik column main pura path likhna hay aab jaisay main nay apni file main link kia hay aap waisay he kardain .... aap ko sirf drag karna para ga aur formula tamam cells main aa jay ga ......

**Mubashir Aziz** · 6th July 2009, 02:21 PM

Jaisa kay di hoi pic main, main nay C4 main yah formula likha

C4=HYPERLINK(A4&"\"&B4)

A4=iss main main nay pura file ka path likha howa hay aap kay case main aap pura path likhain gay C:\documents & settings\username\my documents\ etc.....
B4=iss main, main nay file name likha howa hay jo main Dir command kay zareey hasil kia tha .....
"\"=yah path aur file name ko milanay ka kaam aati hay
aab hyperlink main pura path aay ga aur aap click karnay par uss file par chalain jain gay .......

**kamibest** · 6th July 2009, 02:28 PM

mubsahir aziz said:

Jaisa kay di hoi pic main, main nay C4 main yah formula likha

C4=HYPERLINK(A4&"\"&B4)

A4=iss main main nay pura file ka path likha howa hay aap kay case main aap pura path likhain gay C:\documents & settings\username\my documents\ etc.....
B4=iss main, main nay file name likha howa hay jo main Dir command kay zareey hasil kia tha .....
"\"=yah path aur file name ko milanay ka kaam aati hay
aab hyperlink main pura path aay ga aur aap click karnay par uss file par chalain jain gay .......

Thanks Sir

Maine sahi Tarha Se AP ki File ko read nahi Kiya tah But Maire Problem Solve Hogai hai

once Again thanks

Ye Dekkhe Formula Lagaya hai

**kamibest** · 6th July 2009, 02:29 PM

mai Ap ko reply karaha Tha
Leken Lite Chali Gai thi

Thanks

**Mubashir Aziz** · 6th July 2009, 02:32 PM

Thats great Kamy ..... you always welcome but please next time always write Excel : <your problem> so it will be easy for me to check .......
anyway wish you good luck ....