Rename file, import it, then move it to another dir 1

[brettatexplace]

Need a little help with VBA.

I need to rename a file from x.lst to x.txt . I then have an import macro that works great with the x.txt file. After that I want to move the x.txt file into my "done" directory and rename it to y.txt. What would be the VBA code for this???

Can the rename and move be put into the macro? (how do I convert/export my macro into VBA code?) All pretty simple? Please help. Thanks in advance.

 

[Remou]

Hi
You can use Save As to save a macro as code. Regarding renaming files:

Take a look at the Dir function and at the Name oldpathname As newpathname instruction.
Hope This Helps, PH.

If this is right, thank PVH, if not, blame me.

 

[brettatexplace]

All worked well. Thanks