VBcoders Browse New Submit Contact Sign In

No account? Register free

Forgot password?

Cool and Smooth Access/Excel Charting Demo

Ted Calbazana  (2 Submissions)   Databases/Data Access/DAO/ADO   Visual Basic 3.0   Advanced   Wed 3rd February 2021

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.

Rate Cool and Smooth Access/Excel Charting Demo (8(8 Vote))

Download Cool and Smooth Access/Excel Charting Demo

Cool and Smooth Access/Excel Charting Demo Comments

No comments yet — be the first to post one!

Post a Comment

0/1000 characters