Automate Excel via VB -- Example
Version Compatibility: Visual Basic 5
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.