hi, i made a xls file in a test folder and i want Adding a link to a file inside this folder such as worksheet.Hyperlinks.Add(4 + col, i + 1, 1, 1,"c:\test\test.doc")
but it is a physical address, if i move this folder to another driver such as d:,the link can not work.
Is it posiable to add address like MS excel use relative address? i use code worksheet.Hyperlinks.Add(4 + col, i + 1, 1, 1,"test.doc") can not work :(