Continuously combine all excel files in a folder

This is a common task, so no problem about actually doing it. To make this easiest to get right the first time, please provide the following.

1) 2-3 good sample orders.
2) 1 MASTER file showing the layout of your desired summary. This layout should include a manual mockup of the information from the 2-3 sample orders so we can see exactly how the sample data should be represented in your master.
3) The name of the folder on your system where these folders will be found

--------
When importing files into a consolidation file (master), to keep from importing the same file more than once we need to do one of these:

a) move the imported files into another folder
b) change the name of the import file in a way that make it obvious the file has been imported (for example file1.xlsx becomes file1().xlsx)
c) write a flag into each file that marks the file as imported.

Those options are listed in order of my personal preference, a) is good because if you ever need to "start over", you simply move all the files from the "done" folder back into the main folder and they would be imported again into the new master.

Ok, would have been much easier if the MASTER was the exact same positions as the order forms, but you did mention the master may need to be adjustable. This forced me to "match" the row and columns of the items to update to the master positions of the same items.

For this macro to keep functioning, there must be cells with

Product #
Ral #

...so those columns and rows can be found. In the order form sheets we need cell that have:

Product #
Ral #
Shipping

...so the data range can be spotted.

The macro is installed into the master.

You will need to edit the macro to list the folder addresses to the \IMPORT\ folder and the \MAIN\ folder where the files should go when done.

Please Login or Register  to view this content.

Update links? Yes, I would presume you want to start with a blank master.

I don't really have any MAC conversion tips. Sorry.

I have no MAC experience, but the following link (with sample code) indicates that you may have to add a MacID to the Dir() command: http://stackoverflow.com/questions/1...excel-2011-vba

In addition the Path Separator on a Mac is apparently the colon. See http://stackoverflow.com/questions/1...pc-but-not-mac

The above statements are verified by Microsoft (in the Remarks paragraph) at:
https://support.office.com/en-us/art...rs=en-US&ad=US

Sample Dir() code for MAC courtesy of Ron de Bruin:
http://www.rondebruin.nl/mac/mac013.htm

Unrelated example MAC VBA code:
https://msdn.microsoft.com/en-us/lib...ice.14%29.aspx
http://www.rondebruin.nl/mac/section3.htm

I hope all this points you in the right direction.

Lewis

Thanks Lewis for those sources. I think I'm getting closer but am still getting the error code 68 "device unavailable". Anyone have any ideas? Below is the code I'm trying:

Please Login or Register  to view this content.

Don't forget CODE tags when posting VBA code. I've added it for you this time above.

When you DEBUG at that error, which line is highlighted?

Oh, sorry didn't see the code tags. Now I do.

The line it's highlighting is:

Please Login or Register  to view this content.

I've added coded tags for you again.

https://support.office.com/en-us/art...rs=en-US&ad=US

Based on that "XLSX" is not the correct thing to search for, MacID does not search for the listed text, it searches for the designated file type. From the link above that would appear to be "XLS5"