-
The users of the new computer system I am designing wish to be able to create none standard word documents via my program, print them and then keep a record of the document linked to the client which is held in the client database.
The ideal soloution would possibly be to have word embeded within my program. Then some how diasble the file menu and control where the document is saved and opened via vb code.
Your Hopefully
Jamie Brown
Ps.Any other solutions to the problem would be greatley appreciated.
-
Jamie,
Gaffer and I have answered this - you do it via Automation using the code we previously posted. We aren't going to write the app for you, but you can control how Word works from within VB. If you do all the operations within Word as Macros, it will show you the VBA code you need to replicate in your app.
It isn't rocket science. Go and check out the Microsoft Knowledge base.
Go on, you can do it...
P.
-
Brown,
Paul is right. Automation is a very satisfying facet of VB/VBA, and really not that difficult. As far as embedding Word into VB/Access goes, you can certainly link a document, but I’m not sure if you can actually change a Word document within VB/Access (if it is possible, it’s because I haven’t tried hard enough). To be honest, you have to see it from a user’s point of view – it is far more intuitive for them to have Word open when they click a button than to use it embedded in VB, as to them it will be a familiar. You can disable menus etc in Word from VB however…
-
Gaffer,
Yep, you can change a document - you have full access to all of the things that word is capable of - and that includes text hadling <grin>. You might have to use bookmarks to navigate around etc., but if they are app-controlled templates, shouldn't be too hard.
We can code this app at Bank, next week:)
