using ADO to grab SQL data into Word VBA macro - ADO DAO RDO RDS

This is a discussion on using ADO to grab SQL data into Word VBA macro - ADO DAO RDO RDS ; 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 ...

+ Reply to Thread
Results 1 to 2 of 2

using ADO to grab SQL data into Word VBA macro

  1. Default using ADO to grab SQL data into Word VBA macro

    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.

  2. Default 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.



+ Reply to Thread

Similar Threads

  1. Replies: 2
    Last Post: 10-30-2007, 06:01 PM
  2. Automating a Word Macro from C#
    By Application Development in forum CSharp
    Replies: 1
    Last Post: 10-03-2007, 08:46 AM
  3. Word vba macro
    By Application Development in forum ADO DAO RDO RDS
    Replies: 0
    Last Post: 09-27-2007, 05:46 PM
  4. Word: cannot open macro storage
    By Application Development in forum DOTNET
    Replies: 0
    Last Post: 07-09-2007, 09:23 AM
  5. Running a word macro from a windows service...
    By Application Development in forum CSharp
    Replies: 0
    Last Post: 03-29-2007, 07:48 PM