VBA to Move Files 2

[perrymans]

I am importing files and want to change their location once imported.

After the import completes successfully, I would like to move the list of files to a different folder.

I know how I would allow the user to set the path to the folder, I just don't know the command to move a file.

Thanks. Sean.

 

[alvechurchdata]

You can probably use the Windows Scripting Host for this.

Geoff Franklin

http://www.alvechurchdata.co.uk

 

[genomon]

Or this:

MoveFile Method
         

Description

Moves one or more files from one location to another.

Syntax

object.MoveFile source, destination 

The MoveFile method syntax has these parts:

Part Description 
object Required. Always the name of a FileSystemObject. 
source Required. The path to the file or files to be moved. The source argument string can contain wildcard characters in the last path component only. 
destination Required. The path where the file or files are to be moved. The destination argument can't contain wildcard characters.

"Don't be irreplaceable. If you can't be replaced, you can't be promoted."

 

[perrymans]

What object would I use?

Thanks. Sean.

 

[genomon]

Make sure you have a project reference set to the Microsoft Scripting Runtime library:

Dim fso As Scripting.FileSystemObject
Set fso = CreateObject("Scripting.FileSystemObject")
'....your code
Set fso = Nothing

"Don't be irreplaceable. If you can't be replaced, you can't be promoted."

 

[genomon]

Forgot! Also an example here:

http://msdn.microsoft.com/en-us/library/2wcf3ba6(VS.85).aspx

"Don't be irreplaceable. If you can't be replaced, you can't be promoted."

 

[PHV]

No need of any object:
Name oldpathname As newpathname

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[perrymans]

Sorry PHV, I don't think I understand what you are saying.

 

[PHV]

Name is a native VBA instruction to move file

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886