Part VIIOther Topics

Vertex42 The Excel Nexus

Professional Excel Templates

Get Instant Access

Chapter 26 Compatibility Issues 801

What Is Compatibility? 801

Types of Compatibility Problems 802

Excel File Formats Supported 803

Avoid Using New Features 805

But Will It Work on a Mac? 805

Creating an International Application 806

Multilanguage applications 808

VBA language considerations 809

Using local properties 810

Identifying system settings 810

Date and time settings 813

Chapter 27 Manipulating Files with VBA 815

Performing Common File Operations 815

Using VBA file-related commands 816

Using the FileSearch object 819

Using the FileSystemObject object 821

Locating files that contain specific text 823

Working with Text Files 824

Opening a text file 825

Reading a text file 826

Writing a text file 826

Getting a file number 826

Determining or setting the file position 826

Statements for reading and writing 827

Text File Manipulation Examples 828

Importing data in a text file 828

Exporting a range to a text file 828

Importing a text file to a range 830

Logging Excel usage 831

Filtering a text file 832

Importing more than 256 columns of data 832

Exporting a range to HTML format 835

Exporting a range to an XML file 838

Chapter 28 Manipulating Visual Basic Components 841

Introducing the IDE 841

The IDE Object Model 843

The VBProjects collection 844

Displaying All Components in a VBA Project 846

Replacing a Module with an Updated Version 848

Using VBA to Write VBA Code 850

Adding Controls to a UserForm at Design Time 852

Design-time versus runtime UserForm manipulations 853

Adding 100 CommandButtons at design time 854

Creating UserForms Programmatically 856

A simple runtime UserForm example 856

A useful (but not so simple) dynamic UserForm example 859

Chapter 29 Understanding Class Modules 865

What Is a Class Module? 865

Example: Creating a NumLock Class 866

Inserting a class module 867

Adding VBA code to the class module 867

Using the NumLock class 870

More about Class Modules 871

Naming the object class 872

Programming properties of objects 872

Programming methods for objects 874

Class module events 874

Example: A CSV File Class 875

Class module-level variables for the CSVFileClass 875

Property procedures for the CSVFileClass 876

Method procedures for the CSVFileClass 876

Using the CSVFileClass object 878

Chapter 30 Frequently Asked Questions about Excel

Programming 881

General Excel Questions 882

The Visual Basic Editor 886

Procedures 890

Functions 896

Objects, Properties, Methods, and Events 899

UserForms 910

Add-Ins 915

CommandBars 918

Part VIII Appendixes

Appendix A Excel Resources Online 923

Microsoft Technical Support 923

Support options 923

Microsoft Knowledge Base 923

Microsoft Excel home page 924

Microsoft Office tools on the Web 924

Internet Newsgroups 924

Spreadsheet newsgroups 925

Microsoft newsgroups 925

Searching newsgroups 926

Internet Web sites 928

The Spreadsheet Page 928

Pearson Software Consulting 928

Stephen Bullen's Excel Page 928

David McRitchie's Excel Pages 928

Jon Peltier's Excel Page 929

Mr. Excel 929

Spreadsheet FAQ 929

Appendix B VBA Statements and Functions Reference 931

Invoking Excel Functions in VBA Instructions 935

Appendix C VBA Error Codes 943

Appendix D What's on the CD-ROM 947

System Requirements 947

Using the CD with Windows 947

What's on the CD 948

Author-created materials 948

Applications 961

eBook version of Excel 2003 Power Programming with VBA . . 962 Troubleshooting 963

Index 965

End-User License Agreement 1021

Was this article helpful?

0 0

Post a comment