filename references

's Computer Specifications

i have two excel files. test.xls contains some information i want to
have uppdated to fredrik.xls

this works in test.xls
='U:\tmp\[fredrik.xls]Blad1'!B10

but instead i want to change the filename [fredrik.xls] with a cellname
in test.xls

if i have in test.xls A1 the text-string fredrik.xls who can i then add
A1 in the filename:

this works not but this is the solution i want.
='U:\tmp\[A1]Blad1'!B10

A1 should be replaced with something more between [ ]

's Computer Specifications

i mean i have in A1: test

this i want to have inserted in:
='U:\tmp\[A1.xls]Blad1'!B10

How should A1 be wroted??

's Computer Specifications

I fear this is not possible, because you have tu use the INDIRECT function
which does not work with external Workbook reference.

HTH
--
AP

<(E-Mail Removed)> a écrit dans le message de
news:(E-Mail Removed)...
> i mean i have in A1: test
>
> this i want to have inserted in:
> ='U:\tmp\[A1.xls]Blad1'!B10
>
> How should A1 be wroted??
>

's Computer Specifications

Is it possible to instead copy the cell/row with the value of
='U:\tmp\[fredrik.xls]Blad1'!B10

to a new row and keep exact the same??

If I could do this a can only on the copied row change the filename
manually BUT i must keep the B10 reference. When i copy the cell and
inserts it on another row it always add numbers to B10:
='U:\tmp\[fredrik.xls]Blad1'!B12

This has not to happen. I don't find any way in excel to copy a
cell/row and keep exactly the same to the new row??

's Computer Specifications

You could use this formula:
='U:\tmp\[fredrik.xls]Blad1'!$B$10

or you could just use a formula that points back at the first cell with that
formula:
=A1

(E-Mail Removed) wrote:
>
> Is it possible to instead copy the cell/row with the value of
> ='U:\tmp\[fredrik.xls]Blad1'!B10
>
> to a new row and keep exact the same??
>
> If I could do this a can only on the copied row change the filename
> manually BUT i must keep the B10 reference. When i copy the cell and
> inserts it on another row it always add numbers to B10:
> ='U:\tmp\[fredrik.xls]Blad1'!B12
>
> This has not to happen. I don't find any way in excel to copy a
> cell/row and keep exactly the same to the new row??

--

Dave Peterson

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
HttpPostedFile.saveas(filename) issue when the filename is used "-" as a part of the filename.	Ken	Microsoft Dot NET Framework	0	25th Feb 2009 11:58 PM
auto text: the word Filename precedes the actual filename.	=?Utf-8?B?c2htdWVsZ2ltbWVs?=	Microsoft Word Document Management	0	23rd Mar 2005 07:59 PM
process.start(filename), shell(filename) weird behavior	Peter Proost	Microsoft VB .NET	6	1st Feb 2005 01:37 AM
How to mass convert Filename.eml to Filename.msg while keeping them in original subdirectories?	UncleBob	Microsoft Outlook	2	17th May 2004 06:27 PM
Re: References as part of a filename	Chip Pearson	Microsoft Excel Worksheet Functions	0	21st Jul 2003 06:48 PM