Multi process macro - save open WB, copy data to new WB, del saved...

OK so here is a step by step breakdown of what I need to happen

1- Save all open workbooks to "C:\My Documents\test\"
2- Copy all data from saved workbooks into new "Master File" (Data is only in Columns A and B, data needs to be stacked together in new file)
3- Close and delete previously saved workbooks (could be closed in original operation?)
4- Delete duplicates from new Master
5- Sort column A "A-Z"

I can get all the files to save how I want, I can remove the duplicates from the master and sort it how I want. I just can't figure out how to get the data out of the saved files into a new file and then delete the saved files.

Here are the codes I have been playing with.

This one saves them all

Please Login or Register  to view this content.

This one I found to try and combine them

Please Login or Register  to view this content.

I haven't gotten around to trying to get them to delete, and the remove duplicates and sort is easy enough I won't post that. I just can't figure out how to get the combine code to work for me. I feel like there is a simpler way to do it.

Hi Alex,

Here is some code that saves each open workbook and then deletes them from that directory. I didn't do any code to transfer data since it sounded from your post like you had that handled.

Please Login or Register  to view this content.

Thanks,

Daniel