Print Page | Close Window

AppendValuesToExcel.mdb (intermediate) (2000-2003)

Printed From: Roger's Access Library
Category: Roger's Access Library
Forum Name: Roger's Download Samples
Forum Description: A compendium of Microsoft Access 97 and 2000+ routines, each separated into its own sample database.
URL: www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=522
Printed Date: 15 Dec 2017 at 1:26am


Topic: AppendValuesToExcel.mdb (intermediate) (2000-2003)
Posted By: Roger Carlson
Subject: AppendValuesToExcel.mdb (intermediate) (2000-2003)
Date Posted: 10 Nov 2009 at 7:13am

Please consider donating $1 per sample downloaded, http://www.rogersaccesslibrary.com/whydonations.htm - find out why here .

 
AppendValuesToExcel.mdb
 
This sample demonstrates how to append data from a database to an Excel Spreadsheet using Office Automation to find the next empty row in the spreadsheet.
The overall process:

1) Define Access and Excel object variables

2) Open Excel sheet as an Excel Object

3) Find the last row of data

4) Write data from Access query to Spreadsheet

5) Save and close spreadsheet

Look in the "basExport" module for the relevant code. 

 
Note:  This requires a spreadsheet called "ExportSpreadsheet.xls" (included with the sample) exist in the same directory as the  application.  Also requires references set to DAO 3.6 and Excel
 
Download Access 2000-2003 Version: http://www.rogersaccesslibrary.com/forum/uploads/5/AppendValuesToExcel.zip - AppendValuesToExcel.zip
 
 


-------------
Consider donating $1 per sample downloaded, http://www.rogersaccesslibrary.com/whydonations.htm" rel="nofollow - find out why here .<



Print Page | Close Window