Files to be moved to folder created by another macro

I have the following macro set up to create a folder in a directory as per the contents of 2 cells

C2 = Folder name to be created
B2= Date for previous working day

Please Login or Register  to view this content.

I then have another macro that moves files into a specified folder within the same location ( I then manually move them into the folder the first macro created)

Is there a way I could get the files to move to the newly created folder without me having to do it manually.

I hope this makes sense

You can use the filesystemobject to move files using either .move or .movefile

.movefile is probably better as you can use it to do multiple files at once, i.e. use a wildcard as the sourcefile name. See below from the helpfile. Alternatively loop through the files and use .move for each one.

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.

Remarks

If source contains wildcards or destination ends with a path separator (\), it is assumed that destination specifies an existing folder in which to move the matching files. Otherwise, destination is assumed to be the name of a destination file to create. In either case, three things can happen when an individual file is moved:


If destination does not exist, the file gets moved. This is the usual case.
If destination is an existing file, an error occurs.
If destination is a directory, an error occurs.

This is what I already have set up to move the files

Please Login or Register  to view this content.

Could this be tweaked to achieve what I want?

Just change the destination path to whatever you create in the first macro? For example:

Please Login or Register  to view this content.

As ragulduy says.. .move or .movefile works well..

snb has some nice examples here:

http://www.snb-vba.eu/VBA_Bestanden_en.html#L_85