Re: OutputTo Excel Spreadsheet
- From: AnandaSim <AnandaSim@xxxxxxxxx>
- Date: Sat, 29 Sep 2007 00:09:03 -0700
On Sep 29, 10:41 am, JV <J...@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
If I have a report made up of subreports, is it possible when using the
OutputTo procedure in macros to have have each subreport go on a separate
work*** in the workbook?
Also, is there a way to keep the exact format of the report? For example,
the report has 1 column of information but the exported report in excel has 2
columns one for the data and the then on the next column it has the total. Is
there a way to make it stay in one column?
AFAIK, the Access Report Designer produces its own layout - it can
have lines, shades, subreports, graphics logos etc...
On the other hand, Excel is a grid based program - the two have very
little in common.
They have so little in common that in Access 2007 Microsoft gave up
any pretense of Output To from an Access Report.
On the other hand, with VBA and lots of careful pulling and poking,
one can grab any data from Access and poke it into Excel.
HTH
Ananda
.
- Prev by Date: Re: Embedding PDF file in Report
- Next by Date: Re: Interpolating on an Access Graph
- Previous by thread: how should I tackle building this report???
- Next by thread: Re: OutputTo Excel Spread***
- Index(es):
