Import data and remember file path

[DaveG93]

Hey all,

I need some help with a macro of mine...
I import the same file twice in a macro. So far so good an everything works fine.

The only thing is that I want the macro to remember which file I selected the first time and select it automatically for the second.
Is this possible?
I cannot insert a certain file path, since the file and the path changes.

I'd appreciate any ideas/help!

[Kenneth Hobs]

Sheet1.Range("A1").Value2 = "c:\excel\ken.xlsm"
MsgBox Sheet1.Range("A1").Value2