[AccessD] Reports to Excel

Thanks A.D.,

I will take a look at them.

Thanks,

Mark A. Matte


>From: "A.D.TEJPAL" <adtp at hotmail.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: Tue, 1 May 2007 10:48:04 +0530
>
>Mark,
>
>     You might be able to get some working ideas from two of my sample db's 
>mentioned below:
>     (a) Reports_AccessToExcelAndWord
>     (b) ExportAccessToExcelMultiSheets
>
>     These are available at Rogers Access Library (other developers 
>library). Link - 
>http://www.rogersaccesslibrary.com/OtherLibraries.asp#Tejpal,A.D.
>
>Best wishes,
>A.D.Tejpal
>---------------
>
>   ----- Original Message -----
>   From: Mark A Matte
>   To: accessd at databaseadvisors.com
>   Sent: Tuesday, May 01, 2007 02:14
>   Subject: Re: [AccessD] Reports to Excel
>
>
>   Thanks Jim and John,
>
>   I used...
>   ".Columns.Borders.Color = vbBlack"
>   ...and this seemed to do the trick...
>
>   The export will have a different number of columns and rows each time.  
>The above method puts a border around every cell in the worksheet...not 
>just the data.
>
>   If I could isolate just the cells with data...it might look better...but
>   this will get me by.
>
>   The 'macro recording' gave me a longer approach...but it was dependant 
>on a range...which I'm not sure how to get.
>
>   Any ideas?
>
>   Thanks,
>
>   Mark A. Matte
>--
>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