by Ted Calbazana (2 Submissions)
Category: Databases/Data Access/DAO/ADO
Compatability: Visual Basic 3.0
Difficulty: Advanced
Date Added: Wed 3rd February 2021
Rating: 
(8 Votes)
This VBA Automation demonstration assumes that Microsoft Excel 97 and Access 97 are installed. It hasn't been tested yet with Office 2000. My work required an Excel application that could generate charts based on information in Access. After searching VBC I came upon a great example by Joe Miquel which I've built upon. Once you've started the application all you will need to do is Click on the Excel Button on the Access Form. Feel free to expand and to innovate the code. Many thanks to VBC and to Joe Miguel for a great idea. Hope you like it.
Assumes
Requires Excel and Access 97. Depends on a reference to the Excel Object in Access. Best viewed on a monitor with 1028 x 768 resolution.
Download Cool and Smooth Access/Excel Charting Demo (106 KB)
VBcoders