[AccessD] Reports to Excel

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