I hope someone will be there to help me. I have a table with 1000 records. I want to generate an Excel 2007 workbook(.xlsx) every time when user hit a button on an Access form. I managed to do it by using following code but it allows me to create only a .xls file. I tried changing the file...
