filename contained in a cell to import data

I am writting a macro in order to import data from a .txt file, but the source file name changes according to the user, and the name is contained in a cell (lets use A1)

So far, I know the code line needed to be used to open the file, but I just need to adapt it so the file name is the cell content.

So in this line:

        .Connection = _
        "TEXT;S:(PATH)\log_20130627_112848 .txt"

PHP Code: 

log_20130627_112848 .txt 


need to be modified to use the content of a cell. I know it should be easy, but since I haven't used macros in years, I am at a loss right now...:P

Thanks!