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

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