[AccessD] Export from Access to Excel

Arthur,

    Two of my sample db's mentioned below, might be of interest to you:

    (a) ExportAccessToExcelMultiSheets
    (b) ExportAccessToExcelAsPivotTable

    Both samples (in Access 2000 file format) are available at Rogers Access Library. Link:
http://www.rogersaccesslibrary.com/forum/forum_topics.asp?FID=45

    Sample (a) uses web browser control for displaying destination excel workbook, enabling the user to manually select the starting cell for exported data block. It uses a specimen .xls file as template (optional).

    Sample (b), is not restricted to pivot tables alone and might be found more convenient if you do not wish to install & register a web browser control. It uses .xlt file as template (optional).

    Note: In both samples, use of template excel file is optional.

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

  ----- Original Message ----- 
  From: Arthur Fuller 
  To: Access Developers discussion and problem solving 
  Sent: Wednesday, September 16, 2009 21:57
  Subject: [AccessD] Export from Access to Excel


  Instead of the usual "blank sheet", I want to export to Excel using a
  template (XLT) file. Can anyone tell me how to modify the code so it uses
  the template instead?
  TIA,
  Arthur