Variable File Name
Does anyone know of a way to have a user type in a file location into a
named cell and then use that information in other formula? For instance, assume that a file used once is located at \\server\allocation\space\myexcelMay06.xls Next, lets assume the user types that into a cell that is name FILE I'd like the formula to be able to look into that file at specific cell references to pull information from that file. This is somewhat similar to replacing links, but with a different mechanism. Thoughts? By the way, I probably need to stay away from VB as the end user won't have much support if anything goes wrong. |
Variable File Name
Check out Laurent Longre's INDIRECT.EXT, part of the morefunc.xll free
add-in, at http://xcell05.free.fr -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) wrote in message ups.com... Does anyone know of a way to have a user type in a file location into a named cell and then use that information in other formula? For instance, assume that a file used once is located at \\server\allocation\space\myexcelMay06.xls Next, lets assume the user types that into a cell that is name FILE I'd like the formula to be able to look into that file at specific cell references to pull information from that file. This is somewhat similar to replacing links, but with a different mechanism. Thoughts? By the way, I probably need to stay away from VB as the end user won't have much support if anything goes wrong. |
All times are GMT +1. The time now is 08:30 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com