Open File based on filename in cell

[TOMB]

I am using a combo box / Vlookup to populate a cell -say C3- with file name.
I want to use this to open the selected file.

myFile = Selection.FormulaR1C1
Workbooks.Open Filename:=myFile

However, since 'C3' is a Vlookup formula, the macro tries to open a file
based on the formula rather than the results of the formula.

Is there a way to have 'myFile' be read as the text of the cell contents?

Thanks

TB

 

[Vergel Adriano]

try it this way:

myFile = Selection.Text
Workbooks.Open Filename:=myFile

 

[TOMB]

Perfect. Thanks!

try it this way:

myFile = Selection.Text
Workbooks.Open Filename:=myFile

 

[okrob]

I am using a combo box / Vlookup to populate a cell -say C3- with file name.
I want to use this to open the selected file.

myFile = Selection.FormulaR1C1
Workbooks.Open Filename:=myFile

However, since 'C3' is a Vlookup formula, the macro tries to open a file
based on the formula rather than the results of the formula.

Is there a way to have 'myFile' be read as the text of the cell contents?

Thanks

TB

dim myFile as String
myFile = [C3].Value

 

[okrob]

I am using a combo box / Vlookup to populate a cell -say C3- with file name.
I want to use this to open the selected file.

myFile = Selection.FormulaR1C1
Workbooks.Open Filename:=myFile

However, since 'C3' is a Vlookup formula, the macro tries to open a file
based on the formula rather than the results of the formula.

Is there a way to have 'myFile' be read as the text of the cell contents?

Thanks

TB

This works for me regardless of the formula in C3...

myFile = [C3].Value