Excel spreadsheet as report template

[Allen the Computer Guy]

I am using Office 2007. I have a multipage excel spreadsheet that I want to
use as a template for a report. I would be willing to use each workshhet as
a seperate report. The spreadsheet is a financial statement that includes a
lot of text in cells.

 

[Steve]

The best solution would be to create an Access report that looks like your
existing Excel worksheet. The other option would be to use the
TransferSpreadsheet method to export Access data (probably from a query) to
an empty copy of your worksheet.

Steve
(e-mail address removed)

 

[Mark Andrews]

Or use Excel Automation to fill in each cell with the appropriate value from
the data in Access.
If you have a desire to keep Excel in the mix and have that be the final
output.

Of course you need some code to do this one.

HTH,
Mark Andrews
RPT Software
http://www.rptsoftware.com