XLS export

D

Dan @BCBS

Life would be so good if::
"DoCmd.openform" as you know, will open the form, based on the previous code..
Is there a way to say "DoCmd(output results in xls format)" ?????
 
K

Klatuu

Look in VBA Help for DoCmd.TransferSpreadsheet. It will accept variables for
all it's arguments.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to Write EXCEL files from a FORTRAN Program ? 0
Excel does not accept text format! 0
Exporting from Access 2003 & Access 2007 to Excel 1
Export Report with Graph to Excel error 2495 1
Export Query using Access 2007 to Excel 2003 Users 2
Export Query using Access 2007 to Excel 2003 Users 0
trying to close a form 1
How to export html text as word document with specific size and orientation 0

Top