VBA: Move File and rename it (Use current path)

[LNG2013]

I need help moving a file and renaming a file, but I can't use the traditional:

[COLOR=#009900][COLOR=#009900]Sub DoMove()[/COLOR]
[COLOR=#009900]Name "c:\folder1\test.xls" As "c:\folder2\test.xls"[/COLOR]
[COLOR=#009900]End Sub[/COLOR]
 
 
[/COLOR]

I need to be able to have this run in the current working in directory, this is because the macro gets moved onto different servers to run.

Eg. \folder1\test.xls as \folder2\test-7-18-2011.xls

 

[jpen]

Why do you not use the CurDir function to get the current directory. So it does not matter in which directory your files are located.

 

[LNG2013]

Why do you not use the CurDir function to get the current directory. So it does not matter in which directory your files are located.

Sorry new to all of the VBA stuff, could you show me an example.

 

[jpen]

The best way to get more info is to help the help in VBA. There are also some examples.

 

[LNG2013]

Thanks for the info I tested some things out and still cant get it to work. Any help is always appreciated.