hi... I half figured out how to do this, but came into a bit of a snag.
- What I want to do from VB6 is go to a specific worksheet in an Excel workbook. (i.e. Sheet1)
- Check for the next available row in COLUMN B. (not A). Meaning, the next row without any information written on it.
- Populate column B, C, E, and F with variables I'll capture within my VB6 application.
- Save / Close the the workbook.