Export Acc. Rpt. to Spreadsheet with formatting

A

Abbarition

I have a couple Access 2000 Reports that I am exporting
to Excel 2000 using the Output To function in VB. The
problem is that I need the reports to be landscape with
different margins than the default. Is there an easy way
to apply this formatting besides writing code to create
an Excel object, open the file, and apply the changes?
If it helps, I have a template with the proper formatting.

Thanks!
 

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

Publisher is filling blank lines with data 2
exporting report fields to spreadsheet 1
Export Data from Report or Query to Excel 1
Export Data from an access table to a pre-formatted excel template 1
Macro to export query to Excel 2
Yes/No Data Type format when exported to a spreadsheet 3
Exporting Query in UTF-8 format with VBA 0
Excel templates and transferspreadsheet method 2

Top