[AccessD] Problems Exporting Access Summary Report to Excel

I also found that I didn't really have to learn how to code formatting and
other tricky stuff - just start recording a macro on the spreadsheet, do all
your formatting, cell selecting, or whatever, stop the recording, and crib
the vba code the recording generated.  

And once you have a few of those snippets done, it's just a lot of copy and
paste.

R


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Charlotte Foust
Sent: Thursday, October 31, 2013 10:35 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Problems Exporting Access Summary Report to Excel

That's what I've done too Rocky.  It requires a bunch more code to use
automation, but things get where they're supposed to be.

Charlotte


On Wed, Oct 30, 2013 at 12:54 PM, Rocky Smolin
<rockysmolin at bchacc.com>wrote:

> Can you use a summation query as the source of your 
> TransferSpreadsheet to get the grouping totals?
>
> When faced with more an a simple flat file export I've often had to 
> resort to creating the spreadsheet with automation, and pushing the 
> data directly into the cells where I want them to be.  It's more work 
> but the advantage is that you have total control of the format - 
> column width, row height, font, color, formulas, etc.
>
> Rocky
>
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Brad Marks
> Sent: Wednesday, October 30, 2013 11:10 AM
> To: Access Developers discussion and problem solving
> Subject: [AccessD] Problems Exporting Access Summary Report to Excel
>
> All,
>
> In the past, I have experimented with exporting Access Reports to 
> Excel, but I have never had much success.
>
> Most of the reports that I have worked with in the past were fairly 
> complex (dynamic sorts, dynamic filters, conditional formatting, 
> sub-totals, etc.)
>
> Recently, one of our users has requested that a rather simple Access 
> report be exported to Excel.
> This report reads data from a purchased package's General Ledger tables.
>
> The detail lines of the report are not visible.  There are groupings 
> on Month/Year and on the General Ledger Account Number.  Here is a 
> small example of what the report looks like.
>
>
> Account-AAA  Total $1,000
> Account-BBB  Total $2,000
> Account-CCC  Total $3,000
>    01 2013 Month Total $6,000
>
> Account-AAA  Total $1,100
> Account-BBB  Total $2,200
> Account-CCC  Total $3,300
>    02 2013 Month Total $6,600
>
>
> There are many records in the underlying GL table.  The use of Access 
> Report "Groups" makes it very easy to obtain the sub-totals at the two 
> levels (by Account within Month).
>
> When I try to export the report to Excel, however, things do not turn 
> out very nicely. For example, the Month and Year fields are not shown.
> Instead, "AccessTotalsAmount:" is shown for each cell in this Excel
column.
>
> What I am really trying to ask, is if there is a way to employ report 
> groupings and then be able to successfully export such a summary 
> report to Excel.
>
> Perhaps there is another way to do this.
>
> Thanks,
> Brad
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com