make a new xls-file

[Nirious]

Hi,
I am allowing the user to make an export of some tables to excel,
With some help I can now open a saveFileDialog which returns a path and a filename.
I can also transfer tables to an excel-file

But, how do you create the file itself to transfer to? or is it done automatically with the export?

Nirious

 

[ghudson]

Use the TransferSpreadsheet method to export a table or query to an Excel file. You should choose the name of the file in your code but let the user browse and select where they want the file to go.

Check this out for it might help get you going... Browse [Find a directory or file]

 

[Nirious]

thx

The docmd.outputto command will probably do the job.

Just one more question, is it possible to make a new document empty from within access somewhere on the harddrive?

Like when you would right mouseclick in the directory and choose new->Microsoft Excel Worksheet

Anyway, thanks for helping