Automate Excel via VB -- Example

Category:

Type:

Difficulty:

Author:

Carlos Bladinieres

Version Compatibility: Visual Basic 5

More information:

Use this lines to work with Excel from VB, it works with VB5 and 6. You can use it also with Office 97 and 2000.

Instructions: Copy the declarations and code below and paste directly into your VB project.

Declarations:
Dim ApExcel As Object 'To open Excel

Code: