Word VBA for Access VBA Developers - Microsoft Word


	Back to Microsoft Word Comments List

Word VBA for Access VBA Developers

Edwin Siew

3 days ago

Hi, I only manage to find the above resources on Word. Could someone tell me if there is a Word course on Word VBA bespoken for people who have had some experience with Access VBA? Say, the kickoff focuses on the contrast and presumptions we should not make between Word and Access VBA? For example, the extent to which functions, features and attributes in Access datasheets are not the same as those in Word? Global procedures such as Instr(), Chr(), ConvertCentimetrestoPoints in Excel different from those in Access (which uses char()) etc. etc.? Once I had a hair pulling situation that persisted but randomly for months with the function ConvertCentimetrestoPoints(). Something happened eventually and I began to suspect references for early binding to Excel and Word objects might have functions identical but in name only, and the references are competing to be the one called. Particularly with Word, there is SO MUCH redundancies that intellisense is basically hijacked. try getting fonts to be in bold with the straightforward mindset of someone with a little knowledge in Access VBA. Word creates more background processes than Access too, but they do not prevent further instances of Word objects (but Normal.dot does.. and I wonder now if creating a variable of an Access application from Word is better or creating a Word object in Access is better).

Tons of questions on the interplay but is this fish big enough to fry?

BR,
Ed

	Kevin Robertson @Reply 3 days ago
There are also the Word Tech Help videos. Word TechHelp

	Edwin Siew OP @Reply 3 days ago
Of course, yes. I'll help myself to that if nothing else appears as additional resource.

	Edwin Siew OP @Reply 3 days ago
and thanks!

Richard Rost @Reply

3 days ago

Ed, that's a worthwhile distinction: knowing VBA gives you the language, but Word has its own object model to learn. Kevin's Word TechHelp link is useful, and for the Access-to-Word side, see Export to Word. The free video exports an Access report to RTF; the Extended Cut goes into creating and formatting a Word document through VBA. It's a practical starting point, not a complete Word-versus-Access comparison course.

One correction to your examples: Access VBA uses Chr() too, not Char(). And Word's conversion method is CentimetersToPoints. When automating Word from Access, qualify it with your Word application variable, such as wdApp.CentimetersToPoints(2), assuming wdApp refers to that Word instance. That makes the intended application explicit.

The lingering processes and template behavior need a concrete example before we can diagnose them. Which one operation would you most like to tackle first: formatting text, converting measurements, or closing the Word instance your code created?

Next Unseen