如何创建链接到不同文件夹位置的文件的超链接？ [英] How to create hyperlinks that link to files in different folder locations?

问题描述

我的Excel中有一列不同发票的名称，我需要为每个发票名称创建一个超链接。我尝试按CTRL + K，并开始为每个发票手动创建一个超链接，但这只是太多的工作，因为我有数百个发票。

现在，我使用这个公式：

  = HYPERLINK （C：\Users\Jimmy\Documents\Excel Formula Testing\2015\January&B2和xlsx，B2）
  pre> 
 
 
它的工作正常。但是，并不是每个发票都在这个文件夹中，所以我需要一个从外部文件夹查找文件的公式。
 
 
 
  
解决方案
尝试此公式。这应该适用于您为每个月和一年创建动态超链接。 
  = HYPERLINK（C：\Users\Jimmy\Documents\Excel Formula Testing\& TEXT （A2，yyyy）&\& TEXT（A2，mmmm）& B2&.xlsx，B2）
  
 
I have a column in excel with the names of different invoices on my computer and I need to create a hyperlink for each invoice name. I tried to press CTRL+K and manually create a hyperlink for each invoice at the beginning, but that was just too much work because I have hundreds of invoices. 

Right now, I am using this formula:
=HYPERLINK("C:\Users\Jimmy\Documents\Excel Formula Testing\2015\January" & B2 & ".xlsx", B2)
and it is working fine. However, not every invoice is in this folder so, I need a formula that looks up the file from the external folder.

        
解决方案
Try this formula. This should work for you creating dynamic hyperlinks for each month and year. 
=HYPERLINK("C:\Users\Jimmy\Documents\Excel Formula Testing\"& TEXT(A2,"yyyy") &"\" & TEXT(A2,"mmmm") & B2 & ".xlsx", B2)


                        
这篇关于如何创建链接到不同文件夹位置的文件的超链接？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！