Opening an Excel file based on a Table

[ludfic]

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

 

[Bodisathva]

this thread discusses how to open an external file.

 

[ludfic]

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.

 

[Bodisathva]

I want to load an Access table into an Excel spreadsheet on a form using a button.

look at the help file for DoCmd.OutputTo. use the output to command to create the file, then open it with the shell command.

 

[ludfic]

Thanks for your help. This line of code worked:

DoCmd.OutputTo acOutputTable, "testtable", acFormatXLS, "test.xls", True