Unzip Last file, move it, and Convert it from *.csv to *.xls

[mel]

Hello everyone,

I've been looking everywhere for a code that works for me, but I have no success, could you help me a little?

I would love to understand this code but right now I urge provide solution to something, would appreciate just a suggestion of where I can find documentation to develop what I'm looking for.

My problem is:

every day a compressed .zip file is downloaded to C: \ DUMP, I have many such files in that folder, but I need to capture the last one is downloaded, unpacked and move to the C: \ Dump \ ExtractedFile but not creating a new folder, but only the file.

In addition I need to delete previously existing files in C: \ Dump \ ExtractedFile and have only the last file.

And finally, this file is CSV, could somehow convert it to Excel 97-2000?

Thank you very much in advance and have a great day,

Sincerely,

Mel.

[Squashman]

Do you have excel and an unzipping program installed on your computer?

[ShadowThief]

.xls is a proprietary file type and despite batch and Excel being both made by Microsoft, there's not much they can do to interact with each other.

On the other hand, you can use a VBA macro to do everything you are asking for, and then you only have to use Excel.