Control Microsoft Excel From Access
Control Excel from MS Access now easier than ever before. How do you export an Access table or query to an Excel spreadsheet? How do you import data from Excel to Access? How do you create an Excel chart with Access? Do all this, and much more, with a click of a button.
If you're an Access programmer, you'll be glad to know that this comes as an Access 2000 database, complete with source code. That means it's customizable, and it can grow with you. Think of how much time you will save by doing all these tasks with just a click of a button:
Several screen prints follow.
I program in Visual Basic for Applications (VBA). As you know, you can port Microsoft Excel VBA code into Access. But that's a cumbersome manual process. I know. I've done a lot of that. First, I'd record a macro in Excel. Then I'd copy/paste that macro to Access, embed it within an Excel object, modifying it slightly to work from Access. Finally, it hit me, there must be a simpler way.
Now there is a simpler way. This advanced Access-to-Excel wizard performs two functions. First, with a click of a button you can do many common Excel tasks, such as opening a workbook, exporting data, finding data in cells, formatting cell color, cell borders, cell fonts, creating charts, formatting charts, and so on. Other wizards may perform specialized functions, but this handy tool does many functions, the kind you do every day. And it makes it so easy you may even find some tasks easier to do from Access than doing them from Excel.
But the second function sets this wizard apart from any other on the planet. As it does each task, it also automatically generates VBA code. This code is ready for you to use in your own Access program. Instead of figuring out what code you need to control Excel, a time-consuming task, you get ready-to-use code. In short, it executes the macro and provides the code for you to do it. In other words, it catches the fish and shows you how to fish.
Choose a column, a row, or a rectangular shaped range in order to find values or loop through the cells.
Not only is it easier and faster to perform these functions with a click of a button, but also this Access tool brings to light some obscure features. For example, in the screen print below, notice the difference between chart area and plot area. Did you know that you can format each separately? In Excel you have to right click in exactly the right spot in order to distinguish between chart area and plot area. But here, the difference is easily accessible and obvious. It makes playing with Excel charts easier, faster, and more fun.
You know you can record a macro in Excel. So why not in Access? This tool now uses that same idea to do something similar. It creates perfect subroutines and functions, code that compiles without error, ready to use in your Access program.
You may ask, what kind of code does this tool generate? It can generate code in two ways. It can create subroutines or functions. To give you the most flexibility, as you build your own program, subroutines use no parameters while functions use parameters. Therefore, values are hard-coded into the subroutines, while functions accept values in their parameters. So you can customize the template code for your Access application, and you can build it fast.
Remember, it makes more than just sample code. The VB code compiles error free, and it really works.
You may also ask, after generating code, where does it go? Do you have to copy and paste? Remember now, we're trying to keep copy/paste to a minimum. We want to automate as much as possible, and reduce the manual time-consuming tasks. So just click a button to automatically insert the code into any module of your choice. What can be easier than that? Of course, you can copy/paste if you want to you have lots of options.
Customizable Help Topics? Why not? Just double-click in the list box, and the table pops up where you can add your own help.
The best tutorials have examples. This tool provides example VBA code for Excel faster than you can look it up in a book.
The quickest way to build an application is to start from a template. This tool provides customized template code, not off-the-shelf template code. You make your own choices of ranges, styles, colors, and so on, resulting in the best possible template VB code for Excel.
Download Yours Right Now
Download your advanced Access-To-Excel wizard now and start using it today. Your one-time $9.95 investment will save you hours of time and frustration. It comes in an Access 2000 database, complete with source code, giving you full control.
If you want to test the Access-To-Excel functions without generating VB code, then download the free demo.
Cool Tools for Access