Use Cell as Source file

[ccl28]

Hi,

I would like to use the name in the C4 in Sheet1 as my source file as xls file.
I have written a macro but have error. Attached please find the macro.

Anyone can help.

Thanks.


Sub Macro1()

Range("K10").Select
ActiveCell.FormulaR1C1 = "=[Sheet1!C4.xls]LeakFreq!R39C4"

End Sub

[kassie]

Your code does not help a lot, but
If you want to use a value in a cell to refer to a workbook name, you should
read this value into a varable. Something like wOne = Range("C4").value.
You can then refer to the workbook using wOne. You also cannot mix R1C1 and
A1 references, as you are doing.
ActiveCell.Formula = "='[" & wOne "]LeakFreq'!D39"
would give you the workbook referred to in C4

"ccl28" wrote:

>
> Hi,
>
> I would like to use the name in the C4 in Sheet1 as my source file as
> xls file.
> I have written a macro but have error. Attached please find the macro.
>
> Anyone can help.
>
> Thanks.
>
>
> Sub Macro1()
>
> Range("K10").Select
> ActiveCell.FormulaR1C1 = "=[Sheet1!C4.xls]LeakFreq!R39C4"
>
> End Sub
>
>
> --
> ccl28
> ------------------------------------------------------------------------
> ccl28's Profile: http://www.excelforum.com/member.php...o&userid=36095
> View this thread: http://www.excelforum.com/showthread...hreadid=569812
>
>