书签特殊粘贴，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屋！