Copy Most Recent File to another Directory

Ok, I've also tried using this , which does not work.

Please Login or Register  to view this content.

Any suggestions?

Let me start over.

Below code works for the static filename:IN Stock Status Report - 4717.IRP
However, I need it to copy most recent file (dynamic)since the filename is always different.
Hence,

Sfile = MostRecent(sPath, "IN Stock Status Report - *.IRP")

Please Login or Register  to view this content.

I'm able to copy each Most recent file created to my workbook with the use of:

Please Login or Register  to view this content.

I'm hoping there's a way to setup the code above to find the most recent file.
in a similair way my other code finds the most recent file.

Any help is greatly appreciated.

Thanks.

Bumping.

Is there a way to have one macro script insert code or genereated name into another section of a different macro code? Reason is.. I've got one code
that will return the name of the most recent file I want to have copied.
But, the code that copies will only copy a specified file. As far as I know it
will not copy multiple files (at this code doesn't seem too).

This code will read the most recent file.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Is there a way to have the recent name inserted into the code for the file name within the given path?


Anyone's help / thoughts most appreciated.

Thanks,

BDB

Ok, I tried the following in conjunction with the function code. It doesn't error, but it's also doesn't seem to copy anything to my output folder on the L drive (shared) either.

Please Login or Register  to view this content.

I can't believe it! I got this working completely on my own.
Here's my working solution:

Please Login or Register  to view this content.

Regards,

BDB