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

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


" wrote:

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

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

a écrit dans le message de news:
...
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