AppendValuesToExcel.mdb (intermediate) (2000-2003) |
Post Reply |
Author | |
Roger Carlson
Microsoft MVP Joined: 20 Feb 2008 Status: Offline Points: 261 |
Post Options
Thanks(0)
Posted: 10 Nov 2009 at 7:13am |
Please consider donating $1 per sample downloaded, find out why here. 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: AppendValuesToExcel.zip
|
|
|
|
Sponsored Links | Want a good read? Try The Summer of His Life (available on Amazon!) |
Post Reply | |
Tweet
|
Forum Jump | Forum Permissions You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum |