converting a text string to a formula
Posted by Steven on April 14, 2000 9:34 AM
Anyone,
I would like to convert a textstring into a formula.
In this case the textstring could then be a reference, a link to another workbook.
I don't want to use the INDIRECT function because that requires that the source file is open, I want to avoid that.
example:
cell a1 is a contatenate function giving: 'c:\data\[UN00777.xls]Sheet'!1B11
This is however a textstring and I want te be an actual reference or link
thanks
Steven
Posted by Celia on April 15, 2000 6:20 AM
Steven
Other than INDIRECT, I cant think of any worksheet function ways of doing what you want (but there could well be a lot of ways).
Instead of a worksheet function, it could be done I suppose by an Event Procedure that avoids using INDIRECT.
Alternatively, you could use an Event Procedure to open automatically the Workbook, so that the INDIRECT function would work. In the absence of a worksheet function to do what you want, this is probably the easiest way.
Celia
