-
Chris: smozgur (member here) and I developed an application using only VBA. It was for a company that bought life insurance policies from old people. The investors bet on the odds that the person would die sooner rather than later. So, we developed a system where the user entered everything through a Word userform (NOT forms like I showed ya!). Once the information was entered, the data went into Excel and was made into charts. The charts were copied back into Excel as pictures, and the rest of the data was put into an Access database on the server. The nice part? User is using Word. Never sees Excel or the database. Another cool part? All data is stored in the database and while we created electronic copies of the documents, we didn't need to! They could have been recreated on the fly. The Word userform allowed the user to also choose a salesperson; they entered the potential investment amount, and the name/address/etc. of the potential investor. The document was like 30 pages long. Once a new one had been created and printed, it could be brought up again through the Word form (which was really just a view of the Access DB). It was VERY VERY cool. All VBA.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules