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

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

Report Linked To Excel Causes Access 2007 Crash 1
report to show 5 year trend 1
report not wide enough to make required Excel spreadsheet 4
How do I create a report template in Access 2007? 1
Does anyone have or know where I can get a template for creating . 1
create an acess report from multiple exel files 3
Need Help Urgently - Deadline is Monday 1
use existing report as a template for new Access 2007 reports 3

Top