[AccessD] Reports to Excel

Mark:

My approach is always to start Excel, turn on the macro recorder, do what I
want in Excel,  turn off the macro recorder, and then crib the code out of
Excel and paste into Access.  Works every time and I don't have to acutally
learn anything. <g>

Rocky


Original Message:
-----------------
From: Mark A Matte markamatte at hotmail.com
Date: Mon, 30 Apr 2007 18:14:16 +0000
To: accessd at databaseadvisors.com
Subject: Re: [AccessD] Reports to Excel



Thanks John,

Got it all 'pretty' and stuff.  The only thing left...I need to a put
border 
around each cell???  Any hints?

Thanks,

Mark A. Matte

>From: "JWColby" <jwcolby at colbyconsulting.com>
>Reply-To: Access Developers discussion and problem 
>solving<accessd at databaseadvisors.com>
>To: "'Access Developers discussion and problem 
>solving'"<accessd at databaseadvisors.com>
>Subject: Re: [AccessD] Reports to Excel
>Date: Mon, 30 Apr 2007 11:48:17 -0400
>
>Automation.
>
>
>John W. Colby
>Colby Consulting
>www.ColbyConsulting.com
>
>-----Original Message-----
>From: accessd-bounces at databaseadvisors.com
>[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Mark A Matte
>Sent: Monday, April 30, 2007 11:30 AM
>To: accessd at databaseadvisors.com
>Subject: [AccessD] Reports to Excel
>
>Hello All,
>
>I have an A97 db.  Is there a way to export to excel and control what color
>the header row is in excel?
>
>Thanks,
>
>Mark A. Matte
>
>_________________________________________________________________
>Interest Rates NEAR 39yr LOWS!  $430,000 Mortgage for $1,299/mo - Calculate
>new payment
>http://www.lowermybills.com/lre/index.jsp?sourceid=lmb-9632-19132&moid=1488
8
>
>--
>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

_________________________________________________________________
Mortgage rates near historic lows. Refinance $200,000 loan for as low as 
$771/month* 
https://www2.nextag.com/goto.jsp?product=100000035&url=%2fst.jsp&tm=y&search
=mortgage_text_links_88_h27f8&disc=y&vers=689&s=4056&p=5117

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


--------------------------------------------------------------------
mail2web.com – What can On Demand Business Solutions do for you?
http://link.mail2web.com/Business/SharePoint