Move File

[leonepaolo]

Hi,

I have the good fortune of downloading an 'update file' in the form of xls. I've developed some wonderful code that allows me to import the data from the 'update file'.

Once my import is complete I want to move the 'update file' to another folder. How do I do this?

Thanks in advance,
Paolo

 

[PHV]

Have a look at the Name instruction:
Name oldpathname As newpathname

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886