Hui- can i have your email Id. I will send you one sample file for better explanation.
What I am doing with this code is-
Open the file in which links are there>>> alt+f11>> Insert>> Module>> simple copy this code>> F5.
I appreciate your effort. Guys but I don't know why its not working.
I just wanted to reconfirm that the file/worksheet contains links from different files from different location, as mentioned in my earlier post also.
Yes I have copied it to VBA module. I am using 2007, can it be done on Activesheet. Because if we do Alt+E+K in a file, we could find all links in a worksheet.
Please make it on all active worksheet.
Hi Hui,
Thanks alot for reply. I am new to macro thing, so don't know why this debug is coming.
Debug- For Each h In Worksheets(wsheet).Hyperlinks
In case you want any further clarification. Please let me know.
Hi,
I need help in editing links of a worksheet with more than 100
links like this -
Now excel file is in March'11 folder with below link-
D:F&FFeb 11 - CircleAAGA - AA_F&F_FEB_2010-11.xlsx
D:F&FFeb 11 - CircleABGA - AB_F&F_FEB_2010-11.xlsx
D:F&FFeb 11 - CircleAAOther Cost -...