[AccessD] Excell Question on Reference to Named Cell

Keith Williamson Kwilliamson at RTKL.com
Tue Jun 19 16:44:28 CDT 2007


Anybody ever use this Indirect Function?  I've just incorporated it in a
Master Spreadsheet to bring in data from multiple subsidiary worksheets.
However, I am finding that once I close the subsidiary worksheet....my
data from the Indirect function disappears.  It seems like it only
populates while the other worksheet is open.

Does anyone know a comparable function, that does not require the other
worksheet to be open, at the same time?

Keith E. Williamson | Assist. Controller| kwilliamson at rtkl.com

RTKL Associates Inc. | 901 South Bond Street | Baltimore, Maryland
21231-3305

410-537-6098 direct | 410-276-4182 fax | www.rtkl.com

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Hale, Jim
Sent: Monday, June 18, 2007 6:20 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Excell Question on Reference to Named Cell


This works:
A12    'C:\test.xls'
A13    !May
A14     =A12&A13
A15     =INDIRECT(A14)

A15 returns the value in range "May" in workbook "Test"

HTH
Jim Hale



-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Keith
Williamson
Sent: Monday, June 18, 2007 4:34 PM
To: Access Developers discussion and problem solving
Subject: [AccessD] Excell Question on Reference to Named Cell


Does anyone know how to merge text, to create a reference to a named
cell in excel?

I am trying to pull in Cell A1="V:\Finance\GL_Sched\Assoc\[124.01
Clearing.xls]!" 

Cell A2="May"

I want to merge the two:

V:\Finance\GL_Sched\Assoc\[124.01 Clearing.xls]!May

Which would reference a cell, named "May" on another worksheet.  When I
try this, no matter what I do...excel treats this as text....and won't
bring back the value of "May" from the other worksheet.

Anyone know what I can do?

Thanks,

Keith E. Williamson | Assist. Controller| kwilliamson at rtkl.com

RTKL Associates Inc. | 901 South Bond Street | Baltimore, Maryland
21231-3305

410-537-6098 direct | 410-276-4182 fax | www.rtkl.com 
------------------------------------------------------------------------
--------
The information contained in this communication is confidential, may be
privileged and is intended for the exclusive use of the above named
addressee(s). If you are not the intended recipient(s), you are
expressly prohibited from copying, distributing, disseminating, or in
any other way using any of the information contained within this
communication. If you have received this communication in error, please
contact the sender by telephone at (410) 537-6000 or by response via
e-mail and permanently delete the original email and any copies.

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

***********************************************************************
The information transmitted is intended solely for the individual or
entity to which it is addressed and may contain confidential and/or
privileged material. Any review, retransmission, dissemination or
other use of or taking action in reliance upon this information by
persons or entities other than the intended recipient is prohibited.
If you have received this email in error please contact the sender and
delete the material from any computer. As a recipient of this email,
you are responsible for screening its contents and the contents of any
attachments for the presence of viruses. No liability is accepted for
any damages caused by any virus transmitted by this email.

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com





More information about the AccessD mailing list