Directory Structure in a Macro

Hi Guys,

I'm trying to run a macro that looks like this :

--------------------------------------------------------------------

Please Login or Register  to view this content.

-----------------------------------------------------------------------

The thing I want to edit is with regards to this line:

.LookIn = "C:\Documents and Settings\dhunter25\My Documents\Tests\GMS"



Rather than having a full directory path, i want to look in a folder called
GMS. This folder will be a subdirectory of the folder that this main macro
and workbook are stored in.

Can anyone tell me how to do this?



[If anyone wants to know, the macro will edit a folder full of excel
workbooks all at once by running a macro in another workbook]

Thanks!
Dave

DominicB : Code tags added

Hi Dominic,

try this,

Please Login or Register  to view this content.

Succes,

Erik