Use Cell as Source file

Posted to microsoft.public.excel.programming

ccl28[_5_] ccl28[_5_] is offline

external usenet poster

Posts: 1

Use Cell as Source file

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
delete info from source file w/out changing the destination file	TB	New Users to Excel	0	May 26th 08 06:26 PM
Retaining cell reference in destination, when sorting source file	Mr Reorg	Excel Worksheet Functions	3	April 13th 08 05:11 PM
Linked File Calcuation req. source file to be open	smcd	Excel Discussion (Misc queries)	1	April 19th 06 03:09 AM
Automatic update of links in destination file when source file mo.	Brucgil	Excel Discussion (Misc queries)	0	December 2nd 04 04:07 PM
"file not found" error message when launching source file	Lisa[_9_]	Excel Programming	4	April 6th 04 02:54 PM

All times are GMT +1. The time now is 12:48 PM.

Menu

About Us