Garrett Sever
01-15-2002, 09:58 PM
This one has come up more than once, so I am finally letting the cat out of the bag.
Well... at least its head... I could still tell you guys how to wipe out the macro code so it doesn't pop up those annoying macro warnings once the reports are generated and saved... but that's a story for another time.
So here it is - using OLE Automation and a couple of cheap tricks to turn Excel and Word in reporting tools.
Excel is easy... everything is cell formating and formulas. Word can be more problematic - You must use "bookmarks" to mark where you want your text to go. As I'm more fluent in Excel VBA than Word, some of you may even come up with better ideas.
Enjoy! I accept VISA, PayPal, and firstborn sons. :D
Well... at least its head... I could still tell you guys how to wipe out the macro code so it doesn't pop up those annoying macro warnings once the reports are generated and saved... but that's a story for another time.
So here it is - using OLE Automation and a couple of cheap tricks to turn Excel and Word in reporting tools.
Excel is easy... everything is cell formating and formulas. Word can be more problematic - You must use "bookmarks" to mark where you want your text to go. As I'm more fluent in Excel VBA than Word, some of you may even come up with better ideas.
Enjoy! I accept VISA, PayPal, and firstborn sons. :D