Have you tried stepping through the code? And what does ‘failing’ mean? You get some sort of error? Nothing happens? A file is created, but not as a...
My 10p (I am British :) ) is to try and apply db principles to an Excel workbook. You will not get everything an Access db could give you, but should...