ActiveWorkbook.Path will give you the path of the active workbook.
ThisWorkbook.Path will give you the path of the workbook the code is
executed from.
--
Bob Kilmer


"Paiolas" wrote in message
...
Hi.

I need that a macro find some files in a Folder.

.LookIn = "Folder where this file is" & Range("e12").value
(name of the subfolder to look in)

Can you guys turn this line into code???

Thanks a lot!!!