• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Recent content by AnkitHanda

  1. A

    Marco for editing link in workbook

    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.
  2. A

    Marco for editing link in workbook

    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.
  3. A

    Marco for editing link in workbook

    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.
  4. A

    Marco for editing link in workbook

    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.
  5. A

    Marco for editing link in workbook

    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 -...
Back
Top