Hi Everyone,

One of my reports for work consists of roughly 200 Excel sheets' worth of data. The sheets are contained within 2 books due to data limitations, and each sheet has the same organization and headers. I'd like to combine all of the sheets and create a single pipe delimited text file using VBA.

In other words, the file result will be a massive text file. If you imported it to PowerPivot or Access it would be one big uniform database. Any ideas?