I do very little programming these days, but I try to maintain an application for our church that maintains most of it's bookkeeping and report generation. The application is all done in Excel/VBA, using many forms and several workbooks. Yes, we are using antiquated programs (XP/Office 2003) because we are getting what we need at a cost we can afford, and it works fine except for one function.
My thorn in the side has been the weekly donations. The data is entered by the Treasurer, and names are not uniform (despite all known means of encouragement).
When the treasurer attempts to make corrections, the VBA form seems to get easily confused if tab flow is not followed. Sometimes a control will get focus, but the tab reverts to making a tab instead of progressing to the next control. Then things get really messy. I'm on my fourth version of the form and have been unable to beat this issue.
Since the vb6 form is more robust, I am trying to write a VB6 exe that will handle data entry for this task. I have used Excel as my DB with vb6 several times and understand most of that aspect. My current problem is how to reference the "already open" workbook so that the exe may be started and stopped without opening new instances of the workbook.
I can't seem to find anything anywhere on this, so any suggestions would be appreciated.