transfer all xlsx to directory using VBA

[cmccabe]

I am trying to transfer all .xlsx files from a temp directory to another folder using the below VBA, but currently the destination directory (varDest) is empty. varDest contains the full path to the folder and when I step-through the code it does have the correct value in it, but the files do not transfer. The .xlsx files can be removed from the temp directory once they are transfered. Thank you .

VBA

Please Login or Register  to view this content.

[JBeaucaire]

Maybe change these 3 lines of code:

Please Login or Register  to view this content.

to this:

Please Login or Register  to view this content.

[cmccabe]

I made that change and when I step-through the vba I can see that the directory is there. However, the xlsx transfers to the sheet that the button is in. The attached screenshot shows this. Thanks you .

[JBeaucaire]

Not sure what do with this information.

[cmccabe]

When I run the vba it gets to the section where it moves the 4 xlsx files from the Temp folder (strFolderA) to the new directory (strFolderB). Only as of now I can see the files in the Temp directory but they get sent to the sheet the vba was executed from, not sent to the new directory. Does this help? Thank you .

[JBeaucaire]

Not really. I don't see any code in your post that is capable of copying a worksheet into another worksheet. The only code I see creates a couple of path strings and then moves files between them.

[cmccabe]

Weird, it is supposed to be copying the .xlsx files from the path strFolder A and transferring them to the path in strFolderB, but instead it is copying to the worksheet. The section of code before the transfer is included, does it look right? Thank you .

VBA

Please Login or Register  to view this content.

[cmccabe]

I am getting an invalid procedure call or argument

Please Login or Register  to view this content.

This may be part of the problem? Thank you .

[JBeaucaire]

None of the code you've posted copies data from one excel file into another.

[cmccabe]

Ok, so what is the best way to transfer all the xlsx files in

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

that is what I thought or am trying to do. Thank you .

[JBeaucaire]

I've written code like you've shown virtually identical. I've highlighted the one thing I don't do, I'm assuming that some custom function.

Please Login or Register  to view this content.

[cmccabe]

I will remove that and try again tomorrow (was supposed to be a timestamp on the files but I don't think its necessary). I will let you know tomorrow... thanks for all your help .

[cmccabe]

So when I remove the two lines in red, I can see one of the 4 xlsx files transfer to the new directory but then I get an:

Please Login or Register  to view this content.

with the line in bold highlighted. When I step-though the code Name=Sheet (I don't think that is what I want)? Thank you .

Please Login or Register  to view this content.

[JBeaucaire]

Maybe change this:

Please Login or Register  to view this content.