书签特殊粘贴,Excel查看同一文件夹 [英] Bookmark Special Paste, Excel look in same folder
问题描述
我有一个word文档和一个excel文档,我已经创建了书签和特殊粘贴到excel .....这些书签工作作为长时间,因为文件保留在ORIGINAL位置( example- C: \Documents and Settings\My Documents\New Form )
I have a word doc and an excel doc, I have created bookmarks in word and special pasted into excel.....These bookmarks works AS LONG as the files stay in the ORIGINAL location (example- C:\Documents and Settings\My Documents\New Form)
但是
我需要将文档移动到不同的客户端位置( example- C:\Documents and Settings\My Documents\client1 )
I need to move the documents to different client locations (example- C:\Documents and Settings\My Documents\client1)
excel的单元格信息读取这样;
In excel the cell information reads like this;
= Word.Document.8 |'C:\Documents and Settings\My Documents\ NewForm\TestFactFind.doc'!'!标题'
有没有什么可以放的,所以excel文件会查看其当前的文件夹找到单词文档而不是设置的位置?
Is there anything I can put so the excel file will look into its current folder to find the word document instead of a set location?
推荐答案
非VBA方法
是的,Excel公式可以从af获取值来自与包含文件的公式相同的目录。你必须使用 INDIRECT()
。但是一个谨慎的话。
Yes it is possible for the Excel formula to pick up the value from a file from the same directory where the formula containing files reside. You have to use INDIRECT()
. However a word of caution. INDIRECT will work only if the destination workbook is open.
这是一个例子
让我们来说一下公式
中的单元格B1
C:\Book1.xlsx
Let's say the formula in Cell B1
in C:\Book1.xlsx
is
='C:\Sample\ [Sample.xls] Sheet1'!$ A $ 1
然后将这个公式放在 Cell C1
中进行测试
Then put this formula in Cell C1
for testing it
= INDIRECT(' & LEFT(CELL(filename,A1),FIND([,CELL(filename,$ A $ 1)) - 1)&[Sample.xls] Sheet1'!$ A $ 1)
截图
这篇关于书签特殊粘贴,Excel查看同一文件夹的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!