Exporting a report to Excel

[James Martin]

We use Access's built-in function for exporting reports to Excel quite a bit
and have been very happy with it. However, there are a couple reports that
we'd like to export to Excel and have more control over the formatting of
the produced spreadsheet.

Can anyone make any suggestions as to what the best way would be to do this?
(Our client is using Access 2000 and Excel 2000.)

Thanks in advance.

James

 

[boblarson]

You would use the Excel COM Object model. Check out my post here (near the
bottom).

http://www.utteraccess.com/forums/s...17075&Zd=l&Zn=&Zt=283&Zs=&Zy=#Post1536883&Zp=
--
Bob Larson
Access World Forums Super Moderator
Utter Access VIP
Tutorials at http://www.btabdevelopment.com
__________________________________
If my post was helpful to you, please rate the post.