We help IT Professionals succeed at work.

Exporting to word document via web.

pcorreya
pcorreya asked
on
186 Views
Last Modified: 2013-12-18
I need to find out how I could open a pre-defined word template through the browser and populate it, just like how you would do it using the notes client.

Comment
Watch Question

I think u can use @commands for this.

Once the User clicks on  a button, trigger formulas and open the designated template.

Let me check the exact command.

is this what u want?
CERTIFIED EXPERT

Commented:
I was involved in a project like that once.... we had to install Word on the domino server for it! The server is the location where lotusscript is executed for the browser.
The lotusscript opened word, create a document (populate it), save it, using a unique name based on date/time, attach it on a document and delete the file from disk. Then it was returned to the browser, where the arrachment was launched.

Two ways to populate the word document:
1 - export notes fields to a file and launch a template containing a macro to process that file, or
2 - have notes to write data to the word document

Not too long ago I pasted some code to open a word document (https://www.experts-exchange.com/Applications/Email/Lotus_Notes/Q_20851723.html). You can easily add more subs to write text, create tables, merge cells, change colors etc. The easiest way for a non VB programmer to get to know what code to create in notes is to record a macro in word, launch and step through it. You'll find the same classes and methods when in designer: select a LS event, choose the Reference-tab, select OLE classes and search for "Microsoft Word....".
You'll find more interesting stuff there. At home I should be able to control a force-feedback steering wheel using notes.... if I ever find a purpose to do so.
CERTIFIED EXPERT

Commented:
When you're programming this kind of stuff for the web, please realize that you're running a web agent.
A notes server has 3 agent handlers by default. If -during the process- you agent fails, the open handle may not be closed. Make it crash 3 times and you've lost all handles. That means that no scheduled agent will run either!

Author

Commented:
Thanks Crack, have you by any chance used Microsoft Web Components. Do you know if it is possible using this.
CERTIFIED EXPERT

Commented:
Nope, never used it.

Commented:
I've heard of it... don't yo need to go through signed scripts or somethng to get it to work?
CERTIFIED EXPERT

Commented:
Any progress yet, pcorreya?
By the way, have you seen Q_20906472? Since Notes jobs are getting rare, you might know someone. I.e. if they're still looking....

Author

Commented:
Hi Crak, I haven't had the time to investigate yet. I still need to do the word integration. Where is this question you are referring to.
Pat

Author

Commented:
Hi Crak, thank for that referral. I will get in touch with Kath.
CERTIFIED EXPERT

Commented:
> Where is this question you are referring to.
I don't know.... You're the ozzie, aren't you? Melbourne, that's all I know.
For me that's a 24 hr. flight to work, and another 24 hr to get home again.
Sounds exhausting!  ;-))
CERTIFIED EXPERT
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.