Hey everyone.

I've got this code:

Workbooks.Open ("C:\Documents and settings\tmf\Desktop\NY\TEST\template.xls")

ActiveWorkbook.SaveCopyAs "C:\Documents and Settings\tmf\Desktop\NY\TEST\template1.xls"

I run this code from another file in the some folder "TEST". I would like to be able to run "template.xls" WITHOUT adding the path of the folder "TEST". Of course the file with the code should be in the same folder.

I HTML one just say :\template.xls - how about VBA?

Please help me!

Best regards and thank you.

/Tommy