Hale, Jim
Jim.Hale at FleetPride.com
Mon Jun 18 17:19:36 CDT 2007
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.