Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Clux
 
Posts: n/a
Default How do I reference external data from a file, file name found in .

How do I reference data from a file when the file name is found in
destination workbook. i.e. I want to be able to have a cell whjere i type in
source desitnation file name and the workbook will reference that file in a
range
  #2   Report Post  
Dave Peterson
 
Posts: n/a
Default

If you build your formula with the reference to that closed workbook, excel will
handle it nicely.

I like to open the other workbook.
Build the formula and use the mouse to point at that other range(?) in the other
workbook. Then when I close that other workbook, my formula's syntax will be
perfect--excel did all the real tough work!

If you put the workbook's name (including sheetname, range address) in other
cells and build your formula using these other cells, then the function you'd
want to use is =indirect(). But excel won't let you use this with closed
workbooks.

But Harlan Grove wrote a UDF that allows you to retrieve values from a closed
workbook when you build that string that points at the
drive/folder/filename/sheetname/range address.

http://www.google.com/groups?selm=sH...wsranger. com

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

Clux wrote:

How do I reference data from a file when the file name is found in
destination workbook. i.e. I want to be able to have a cell whjere i type in
source desitnation file name and the workbook will reference that file in a
range


--

Dave Peterson
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
File Error: Data May Have Been Lost Tbird2340 Excel Discussion (Misc queries) 8 March 20th 05 06:31 PM
Weekly Transaction Processing Ralph Howarth Excel Worksheet Functions 4 January 19th 05 06:37 AM
Pulling data from 1 sheet to another Dave1155 Excel Worksheet Functions 1 January 12th 05 06:55 PM
How can I check if data in an external data range is changed afte. Ruud Excel Worksheet Functions 0 January 7th 05 01:15 PM
Fetching External Data from Excel Sri Excel Discussion (Misc queries) 2 January 3rd 05 12:46 PM


All times are GMT +1. The time now is 05:53 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"