Formatting Techniques for Data Access from Excel VBA

In this article, the second of two parts, you will learn about the two formatting methods you can use when dealing with Excel, Access, and VBA. It is excerpted from chapter three of the book Integrating Excel and Access, written by Michael Schmalz (O’Reilly, 2005; ISBN: 0596009739). Copyright © 2005 O’Reilly Media, Inc. All rights reserved. Used with permission from the publisher. Available from booksellers or direct from O’Reilly Media.
Continue reading

Data Access from Excel VBA

In this article, the first of two parts, you will learn how to handle situations in which VBA is the only way to obtain data (such as when you want to restrict access to data). It is excerpted from chapter three of the book Integrating Excel and Access, written by Michael Schmalz (O’Reilly, 2005; ISBN: 0596009739). Copyright © 2005 O’Reilly Media, Inc. All rights reserved. Used with permission from the publisher. Available from booksellers or direct from O’Reilly Media.
Continue reading

Upgrading Visual Basic 6.0 Applications with Visual Basic .NET 2003

Upgrading Visual Basic 6.0 applications to .NET involves a good bit of automation thanks to an upgrade wizard. Even so, there are certain issues involved, and some applications might be better off left in VB 6. This article will take you step by step through an upgrade, explain the core issues, and help you decide which of your applications to upgrade.
Continue reading