Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Evaluate text string as formula
Hi Everyone,
I have the following code to get a a cell linked to another workbook, but when i call the function it returns a #REF!. The function is trying, for example, to do the following: Evaluate (='H:\bravhec\[Book1.xls]Sheet1'!A1) Function GetRange(FilePath As String, FileName As String, SheetName As String, _ SourceRange As String) Dim link As String 'Add formula links to the closed file link= "='" & FilePath & "\[" & FileName & "]" & SheetName _ & "'!" & SourceRange Application.CutCopyMode = False GetRange = Evaluate(Link) End Function thanks in advance! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is there a function that will evaluate a text string in a cell? | Excel Worksheet Functions | |||
Evaluate text string as a function | Excel Discussion (Misc queries) | |||
Evaluate string as a formula | Excel Worksheet Functions | |||
how to evaluate the content of a string as if it was a formula | Excel Discussion (Misc queries) | |||
VBA Function to evaluate hlookup text string as formula | Excel Programming |