Macro to retrieve file from a folder and basically update the format

[drobinson782001]

I WOULD LIKE TO Create an Excel MACRO or script that will retrieve files from a directory and use the info within that file to populate a file labeled “This_is_how_the_new_layout_should_look.xls”

· It should auto execute when opened

· Should list the files to be process located within the c:\ directory (example mobile_sprint_20131008932000.xls) ***GET THE MOST RECENT FILES*****

When the “This_is_how_the_new_layout_should_look.XLS” file is open it should have 2 buttons EXECUTE and QUIT

When They click the EXECUTE it should

Copy the file from the directory(where the ORIGINAL file is stored example C:\ mobile_sprint_20131008932000.xls ) use the info within that file to populate the file labeled “This_is_how_the_new_layout_should_look.xls” (THE File is ATTACHED and stored in the same directory)

Once that is done a message box will pop up to show completed.

Then finally it should save the file with the same naming convention as the ORIGINAL file with a _Load .csv as its prefix

Example mobile_sprint_20131008932000_Load.csv. ****BUT KEEP THE ORIGNAL FILE******

I have attached how the file arrives in the folder, and what the completed worksheet should look like

PLEASE ASSIST Thanks

[drobinson782001]

SO the main idea is to have a template that has 2 buttons EXECUTE & QUIT on one sheet. on the other sheet is the headers with the new layout
once the execute button is clicked, it should go the the folder where all the files come in (c, copy the info from that raw file which has headers also, and paste into the new formatted xls file. once all is done, automatically save the updated file with a _load.xls extension and place it back into the folder