A common situation is to prepare invoices, etc. from information in a database. Clients usually have extremely customized invoice formats, but the data to be filled in is basically the same. This article and its related code present a new (I have searched, but could not find anything related to this topic, so I believe it’s new), innovative, and productive way of producing dynamic Office documents. I am using the word Office in this entire document as it does not relate solely to Microsoft Office. I have tested this approach on Open Office as well, and it works. The associated code enables to perform Token Replacement on both Office products.
Again, due to a larger community available at CodeProject, this article together with its Source Code is available if full at:
http://www.codeproject.com/KB/office/OfficeTokenReplacement.aspx
The Code for the article is also attached below.
UPDATE:
- (Feb 24, 2010) – Fixed a minor bug in replacement of header/footer sections.
Excellent article, i just want to thank you for good read..
This is exactly what I was looking for, gracias
Your blog is full of interesting articles, thanks for good read
Very interesting blog, bookmarked for the future referrence, what template do you use ?
Hi, which template are you talking about??
Hey, I found your blog while searching on Google your post looks very interesting for me. I will add a backlink and bookmark your site. Keep up the good work!
I often read your blog, i think you are good writer, keep us posting
You have to express more your opinion to attract more readers, because just a video or plain text without any personal approach is not that valuable. But it is just form my point of view
Your blog keeps getting better and better! Your older articles are not as good as newer ones you have a lot more creativity and originality now. Keep it up! And according to this article, I totally agree with your opinion, but only this time! 🙂
if data of the body of invoice exeed the page , the new page is managed from your office token replacement?
Grazie mille Mirko
suppose in the invoice i have 200 product rows with code, qty, descriptions … and so on, what can i do, using your routine to replace tokens. After filling the first page , with for example only 20 rows , how can i go on to have the others 20 pages of the invoices
tanks