Search results

Thanks for your help. This line of code worked: DoCmd.OutputTo acOutputTable, "testtable", acFormatXLS, "test.xls", True

Thanks for replying. It is not as simple as opening an external file. The Excel file that I want to open doesn't exist. Here, let me re-phrase: I want to load an Access table into an Excel spreadsheet on a form using a button.

Hi What I want to do is following: Open an Excel file based on an existing Access table. This event will be triggered by pressing a button on a form. Could anyone please point me in the right direction? Regards