 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / November 2007importing a cell value
I need to import a cell values from an un-opened .xls using a variable address ie cell A34 = the location of the .xls on our server (j:\121213\Drafting\Quants\) "105 White Ant" = the name of the .xls B3 = the cell I need to import C6 = value(A34+"105 White Ant"+B3) Any help or advice would be hugely appriciated Sorry I should also have specified that I want to avoid the use of macros. > I need to import a cell values from an un-opened .xls using a variable address > ie [quoted text clipped - 6 lines] > > Any help or advice would be hugely appriciated You would normally use INDIRECT to do this, but it will only work with workbooks that are open. If you want to avoid macros or add-ins (such as Laurent Longre's morefunc or Harlan Grove's PULL function), then you will have to open your second workbook. Hope this helps. Pete On Nov 5, 2:51 am, Kristian G <Kristi...@discussions.microsoft.com> wrote: > Sorry I should also have specified that I want to avoid the use of macros. > [quoted text clipped - 10 lines] > > - Show quoted text - One way to approach this is to construct a "Text" formula, which can reference your variables, and then convert that "Text" formula to an XL "legal" formula. See if this old post helps: http://tinyurl.com/35tkzu  SignatureHTH, RD ===================================================== Please keep all correspondence within the Group, so all may benefit! ===================================================== Sorry I should also have specified that I want to avoid the use of macros. > I need to import a cell values from an un-opened .xls using a variable > address [quoted text clipped - 7 lines] > > Any help or advice would be hugely appriciated
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.