使用间接功能的链接 [英] Links using indirect function

问题描述

使用间接功能链接到其他电子表格时出现问题。

I have a problem when using the indirect function to link to other spreadsheets.

我要关联的电子表格包含不同名称的表单。我正在尝试创建一个引用电子表格中单元格的工作表名称的参考和 用它来引用另一张表中的特定单元格。目前我通过使用addess和间接函数的组合来实现它。 

The spreadsheets I'm linking to have sheets with different names. I am trying to create a reference that take the sheet name from a cell in the spreadsheet and use it to refer to the particular cell in another sheet. For the moment I am doing it by using a combination of the addess and the indirect functions. 

示例：  = INDIRECT（ADDRESS（23; 3 ;; ; [filename.xls]"& A2&""）） 

Example:  =INDIRECT(ADDRESS(23;3;;;[filename.xls]"&A2&"")) 

其中A2包含工作表编号 我想在名为filename的电子表格中链接到.xls的。

Where A2 contain the number of the sheet I want to link to in the spreadsheet named filename.xls.

我需要这种方式的原因是模型每个月都会更新，并且需要更改许多单元格才能手动完成。

The reason I need it this way is that it the model is updated each month and there is to many cells to change to do it manually.

问题是这种方法要求我提到的所有电子表格都必须打开。我的第一个问题是，有没有办法解决这个问题？可以 我使用相同的方法而没有我所指的电子表格打开吗？

The problem is that this method requires that all the spreadsheets I refer to has to be open. My first question is if there is any way around this? Can I use the same method without having the spreadsheets i refer to open?

其次，如果不可能的话。创建宏的最佳方法是打开文件，然后再次关闭它们以进行模型更新？这里需要考虑的问题之一是，我所提到的几个文件的名称都是
（并且我不能更改它们）。 

Second, if it is not possible. What's the best way to create a Macro that open the files and then close them again to make the model update? One of the problems needed to be considered here is that several of the files I refer to have the same name (and it is not possible for me to change them). 

我希望我的问题清楚明白。

I hope my question was clear enough to understand.

祝你好运，

Martin Gustavsson

Martin Gustavsson

推荐答案

也许你应该看看除Microsoft Small Basic论坛以外的其他地方。
这是一个很好的起点。

Maybe you should look somewhere else other than the Microsoft Small Basic forum. Here would be a good place to start.

这篇关于使用间接功能的链接的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！