Hi,

I have searched the internet for more then one hour to find an answer to my question, but sadly I couldn't find it ... So here it is:

I have two documents (.xls and .csv). They are going to be always in one folder, BUT different location. For this I have looked up the following code, what works just fine:

Function mPath() As String
mPath = ThisWorkbook.Path
End Function
Then if I type into any cell the =mpath() function it will give me the location of my document. My problem starts here ... I don't know how I could include a code into my Macro so it will reference to that cells address.

I hope it's understandable what's I'm trying to achieve ... If not then I'll give it another try.

Thanks,
George