DataBase - Word Automation and formatting

Asked By Bonnie
03-Nov-09 10:52 PM
I have an Access VBA module that outputs to a word doc (automation) and I was
wondering if anyone knew the best/easiest way to bold a section of the text
as I am outputting it to word?  This is an existing project that I am just
tweeking so I cannot redesign it.  What I want is the first few words of
several paragraphs bolded.

Thanks,

Bonnie
Word
(1)
VBA
(1)
Stiphout
(1)
  Tom van Stiphout replied...
03-Nov-09 11:23 PM
Do it in Word, with the macro recorder running, and see what it spits
out.

-Tom.
Microsoft Access MVP
  Bonnie replied...
04-Nov-09 01:25 PM
Good suggestion Tom.  I did it and got the code.  The problem I am having now
is looping the macro to get them all.  I am not that familiar with Word vba
and, though it would be an easy proposition in Access, finding the end of the
doc in Word seems to be a problem.

Thanks,

Bonnie
help
dont and I was just wondering if others do. Cheers The Frog Access Discussions Excel VBA Macros (1) David W. Fenton (1) Office 2010 (1) Office (1) Excel (1) Word (1) Routine (1) Module (1) You know, I think you make a good point. I OP meant the Friend keyword as it is supported by most object-oriented languages. Alas, VBA is not one of them. -Tom. Microsoft Access MVP Hi Guys, Eggs, you are of appalling language and lack of common courtesy for example in various Java newsgroups and Excel VBA Macros. On the whole I prefer to spend my limited time here to learn from and knowledge (sucking up is friendly right?). Tom, the OO keyword Friend is available in VBA, I am just not sure that it has any use. To quote from the helpfile Tom. Microsoft Access MVP Tom, you may be right. An add-in to elevate the VBA IDE to the capabilities of full VB6 probably wouldnt be a bad idea. Be a write I imagine as you would have to be extremely careful not to 'break' the VBA environment and that anything written was compatible with VBA environments that dont have the add-in. With A2010 (which I havent seen yet, I
How to delete embedded Word object? DataBase I have an embedded Word document in an unbound object frame. I want to delete the object from the object frame using VBA. How do I do it? My goal is to let the user select Word documents and edit them in-place in the unbound object frame, so I have to tried setting the Action to acOLEDelete and that also does nothing. Access Modules DAO Discussions Word (1) VBA (1) Tom van Stiphout (1) SourceDoc (1) Database (1) Tom Many (1) Word document (1) This worked for me and switched to the second doc: OLEUnbound23.Action = acOLEDelete
one book on automating Mappoint, but it uses C#. . . . Can this still be done through VBA? Thanks, Pieter - - Message posted via AccessMonster.com http: / / www.accessmonster.com / Uwe / Forums.aspx / access-modules / 201005 / 1 Access Modules DAO Discussions Silverlight (1) Outlook (1) Word (1) VBA (1) Map (1) Microsoft Access (1) Tom van Stiphout (1) Pieter Message (1) I did some intial playing around with it 5 years ago documentation on the MapPoint Object Model. Fundamentally, its just like automating Outlook from Access or Word from Outlook, etc. You just need to know the various objects, properties and methods. On Tom. Microsoft Access MVP Thanks, Tom. Do you know if I can automate it using VBA or do I have to use a .NET language? I found only one book published
1) Windows Update (1) Windows 7 (1) Vista (1) Excel (1) PleaseNOOSpamKallal (1) ReportToPDF (1) VBA (1) Yes. Yes. -Tom. Microsoft Access MVP Tom van Stiphout wrote: Excellent. Thanks Tom. Based on your reply, I was asked to develop a project They are not different formats at all, it is just that one has the canonical VBA code stripped out. - - David W. Fenton http: / / www.dfenton.com / usenet at dfenton dot com editing junk that is also running. And, lets not forget the basic office stuff like word, outlook and them browsing the web I mean, if you just running office (outlook, excel to so it may be an internal, external report or both. And I use the word "report" loosely since it the output is an Excel file. In running some time tests
haystack. Could anyone give me a pointer on how to do more than a one-word search on this forum? Thanks, OldBlindPew Access Forms Discussions VBA (1) ValidationRule (1) ValidationText (1) BeforeUpdate (1) Stiphout (1) MyText (1) Years (1) Esc (1) it is not odd to me. I think In the rare case I want that, I would program it myself (e.g. using VBA code in the <control> _BeforeUpdate or Form_BeforeUpdate). Conditional Formatting is not primarily to be used fall just short of the goal, leaving one to face the truly horrific prospect of VBA. However, for now, I have decided to be content with just changing the font color