Re: using ADO to grab SQL data into Word VBA macro



Rick Charnes wrote:
I would like to use ADO to grab data from a SQL Server database into
my Word VBA macro. I think I have the code, but I don't know how to
add a reference to the Microsoft ActiveX Data Object 2.x Library to
my Word VBA project. Is there someone who could help me with that?
Thanks much.

I haven't used the Word VBA IDE, but in Access and Excel, it's Tools >
References
--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.


.



Relevant Pages

  • RE: Spanish in Word 97
    ... personal experience :-) ... I highly recommend getting away from Office 97. ... oddities in the Word VBA interface. ... This reply is posted in the Newsgroup; ...
    (microsoft.public.word.spelling.grammar)
  • Re: speed the running of VBA
    ... its hardly Word VBA now is it :-) ... really want to go char by char use some mechanism like ... Word's direct serialization of the paras each time you reference one. ... >> back to the newsgroup so that others can see it, ...
    (microsoft.public.word.vba.customization)
  • Re: Help
    ... is for Word VBA. ... Please reply to the newsgroup unless you wish to avail yourself of my ... Dim sht As Worksheet ... For Each sht In ActiveWorkbook.Worksheets ...
    (microsoft.public.word.vba.general)
  • Re: Do Like AutoCorrect in .Net C# Word AddIn
    ... You may have better luck if you post to one of the Word VBA ... Please post all follow-up questions to the newsgroup. ... WHEN a Word User types a word I want my AddIn to ... substitute for that word - just like AutoCorrect does. ...
    (microsoft.public.word.docmanagement)
  • Re: Do Like AutoCorrect in .Net C# Word AddIn
    ... You may have better luck if you post to one of the Word VBA ... Please post all follow-up questions to the newsgroup. ... WHEN a Word User types a word I want my AddIn to ... substitute for that word - just like AutoCorrect does. ...
    (microsoft.public.word.docmanagement)