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
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
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 .......
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 .......
aoa bhai sub ko select karo and past in to excel sheet it take time lakin sub ho jain gi inshallah
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 ......
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 .......
mai Ap ko reply karaha Tha
Leken Lite Chali Gai thi
Thanks
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 ....
ok
Bookmarks