Make a macro bigger than 64k

I need a macro to go through over 5000 files and seperate thoese files into 20-25 differend spreadsheets. I can do this upto a point but once i hit over 64k it wont work. Knowing that this has been a standard since the early office/windows 95 days. Is there a registry hack or anything with faster computers these days to make it read them?
any help would be great. Included is one I wrote for a smaller batch that seperates usually about 1200 files into 4 different spreadsheets.