Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Function to change text to formula
Hi,
I am creating a spreadsheet which links to many other files in different directories. The user selects the files and the pathsnames etc are returned using "GetOpenFilename". My idea was to concatenate the filepath with the worksheet name and cell reference to create a formula. If l copy and pastespecial values the concatenated result into a new cell then using edit place = in front all works OK. I can also write VBA code to achieve same but there are too many cells to make it feasable. Is there or does anybody know the code to create a function that will take text and convert to a formula. Any suggestions would be great. Regards Michael beckinsale. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Function to change text to formula
There is no such built in function for linking to closed workbooks. For
open workbooks, you can use the Indirect formula. I don't understand how too many cells is an issue with using a macro. A macro can perform the same repetitive action on all your cells - perhaps you could elaborate. -- Regards, Tom Ogilvy "Michael Beckinsale" wrote in message ... Hi, I am creating a spreadsheet which links to many other files in different directories. The user selects the files and the pathsnames etc are returned using "GetOpenFilename". My idea was to concatenate the filepath with the worksheet name and cell reference to create a formula. If l copy and pastespecial values the concatenated result into a new cell then using edit place = in front all works OK. I can also write VBA code to achieve same but there are too many cells to make it feasable. Is there or does anybody know the code to create a function that will take text and convert to a formula. Any suggestions would be great. Regards Michael beckinsale. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can Text Function change output text color? | Excel Discussion (Misc queries) | |||
how to change number to text with specific format in function | Excel Worksheet Functions | |||
trying to change Proper function results to text? | Excel Worksheet Functions | |||
Is there a function to change a number to text? | Excel Worksheet Functions | |||
Change Text-color depenting on SUM-function | Excel Worksheet Functions |