opening a file from a cell reference

[sfielder78]

I think this should be quite straight forward.

I would like to open a text file based on a cell reference

i.e. "example.txt" in cell A1.

Thanks

Simon

 

[Guest]

Try
Worksheets(Range("a1").value).activate

 

[papou]

Hello Simon
Pretty straightforward, yes, provided info in A1 comporises of the full path
and name of the file.
eg:
Sub OpenFileNameFromCell()
With Worksheets("Sheet1")
If .[A1] <> "" Then
Workbooks.OpenText .[A1]
End If: End With
End Sub

HTH
Cordially
Pascal