Open file with file name from cell

[Thore]

Hi all,

here is a real beginner question: I have got a named cell
with path & xls-file name in it. What code do I need to
open that specific file with a macro?

Closely related to that topic: Do I always need the entire
path or is it somehow possible to use a "relative path"
from the location of the file where the macro is stored in?
Finally, how do I remove a cell name so that the cell is
again referred to as A1 or whatever? Simply deleting the
name from the Name Box does not work...

Thanks in advance,
Thore

 

[BrianB]

Code:
--------------------

Dim MyPath As String
Dim MyFile As String
'-----------------------
MyPath = ThisWorkbook.Path & "MyFolder\"
MyFile = MyPath & ActiveSheet.Range("MyName").Value
Workbooks.Open FileName:=ActiveSheet.Range(MyFile).Value

--------------------

remove a cell name

Insert/Name/Define ... select name and Delete.