|
-
Oct 18th, 2014, 02:38 PM
#7
Re: Creating an ESTIMATE or INVOICE where to start?
If it were me, I'd totally use Microsoft Word Automation through VB6. I could have this up and running in 2 hours max using Word Automation.
I've attached an example of a recent report I did using a combination of Word and Excel Automation, all done from within VB6. Every single number on this form was filled in from a database that was also accessed via VB6.
As a tip, I often use the "Record Macro" functions in the VBA of Word and Excel, and that recorded code will almost directly paste into your VB6 application. You may need to patch up the "Document" object a bit, but the rest of it'll go straight in. For security reasons, I tend to not have any macros in my actual Word and Excel documents.
Also, I make extensive use of the "Template" (.DOT, .DOTX, .XLT, & .XLTX) files of Word and Excel. That way, the user is much less likely to mess up your report templates.
Sample.pdf
Good luck.
p.s. In the past, I've extensively messed around with Crystal Reports, and also tried to build a VB6 interface between VB6 and the Microsoft Access Report engine. However, after learning the Word and Excel object structure, I've found that Word and Excel automation is TOTALLY the way to go regarding report generation via VB6.
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
|
Click Here to Expand Forum to Full Width
|