relative path.
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!!!
|