The power of Microsoft Access to Excel VBA is revealed here in this quick two and half minute video demonstration of how popular Microsoft Office applications are & can communicate when using Access VBA (Visual Basic for Application code)
Microsoft Access To Excel VBA – Automating Between MS Office Applications
Now you’ve seen it done – how does it work? Using Access to Excel VBA requires some foundation VBA code knowledge and may say they are not programmers – well that’s good news!
Being a programmer can hinder your approach and taking simple principles that I teach you will give you the tools and knowledge to build and automate not only Access databases but send data to and from other Office applications (i.e. MS Excel).
To start with, review some of the basics and then talk to me and see if we can work on structured coaching programme for you and focus on the real specifics that you only want to know. Give a me a call.
Tags: Access to Excel VBA, access vba, access vs excel, excel vba, MS Access, ms access export report to excel
Using VBA code to talk to and Excel Chart is about create a chart object in Excel and adding an additional reference. The best way to start would be to record a macro in Excel and use this code as the base to get started and transpose it into Access VBA since it’s the same language – only uses different libraries.
I had similar problem and I approached it using MS Query to get data from MS Access to Excel. Query is built in MS Access and when the Excel is opened it gets output of that query and does all the charting. VBA is cool…just stating MS Query is one other option. Thanks for sharing.