Excel spreadsheet as report template

  • Thread starter Allen the Computer Guy
  • Start date
A

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.
 
S

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
[email protected]
 
M

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
 
Top