[AccessD] Creating a Spreadsheet from a Report

Rocky,

    If you are in a position to put in the required effort, my sample db named  Reports_AccessToExcelAndWord  might be of interest to you. It is in access 2000 file format and is available at Rogers Access Library. Link - 
http://www.rogersaccesslibrary.com/forum/forum_topics.asp?FID=45

Best wishes,
A.D. Tejpal
------------

  ----- Original Message ----- 
  From: Rocky Smolin 
  To: 'Access Developers discussion and problem solving' 
  Sent: Thursday, September 16, 2010 02:39
  Subject: [AccessD] Creating a Spreadsheet from a Report


  Dear List:

  I have a client who wants one of the reports in my app to be exported as a
  spreadsheet.  But nota flat file.  She wants the spreadsheet to look like
  the report - header line, details with their own fields headings, plus two
  other sub reports.  

  I've done this with other reports on a cell by cell basis where the Transfer
  method won't work.  Big PITA.  Is there an easier way to do this?

  MTIA

  Rocky