[AccessD] Problems Exporting Access Summary Report to Excel

Oh I found that out the first time I looked at a recorded macro.  NO, not
cut and paste but at least it told me how to select cells, and bold stuff,
and all that other object model that I couldn't ferret out for myself.

Sorry about the delayed response.  It IS sunny and 74 in S.D.  Like every
day. :)

r 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gustav Brock
Sent: Thursday, October 31, 2013 2:35 PM
To: accessd at databaseadvisors.com
Subject: Re: [AccessD] Problems Exporting Access Summary Report to Excel

Hi Rocky

It is not that easy. All that provides is "dirty" code which, though
working, needs a lot of clean up. Recorded macros are filled with selects,
active this-and-that and simple cell references where you should use
specific worksheets and ranges and no selects.
Also, if possible, do define Named Ranges for whatever fixed cell range you
will manipulate.

It takes a little more work but you will never regret. You will be proud of
yourself, no more pointing fingers. The sun may even shine on you (ah, oh,
no big value if you still live in San Diego).

/gustav

>>> rockysmolin at bchacc.com 31-10-13 19:06 >>>
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

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com