Access-To-Excel Tool 1.00 Overview

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. 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.