Is it possible to move an Excel file which is open and running VBA code from one directtory to another?

i.e the VBA code moves the .xls file it is running from.

Yes! it's possible in Three steps

VBA code must store Activeworkbook.path & "\" & activeworkbook.name to a string variable previousFile

Next Save the current file to new location (e.g activeworkbook.save \dfdkf\dfkdfk)

Next Kill previousFile

The file is moved! WoW!

Regards
Amjad Mahmood

Ah! Good idea. Done & works fine thanks.