SQL -> Word VB/VBA Automation

Results 1 to 3 of 3

Thread: SQL -> Word VB/VBA Automation

  1. #1
    Kentium Guest

    Default SQL -> Word VB/VBA Automation

    Hi. I&#039;m *still* looking for a good tutorial on how to get SQL data into a Word document.<BR><BR>Seems like there&#039;s plenty of info on getting Access data into a Word document...but not much on SQL.<BR><BR>Anyone got some juicy stuff for me?<BR><BR>Thanks!

  2. #2
    Kentium Guest

    Default Oh ooooh...

    http://support.microsoft.com/support/kb/articles/Q286/0/23.ASP<BR><BR>I think this is what I want. Any nods or nays?

  3. #3
    Join Date
    Dec 1969

    Default oops my bad last time

    I just realized that the scenario you previously described is with the user sitting & looking at a web browser. I had the user looking at MS Word. Duh.<BR><BR>The microsoft method involves creating an ActiveX component (which I&#039;m not entirely comfortable with), but it looks like it has all the stuff you need. The source for the Invoice.cls has very good stuff: connection string to the DB, and Sub MakeInvoice shows very nicely how to shove variables into bookmarks (see invoice.doc for the bookmarks).<BR><BR>I like it (bookmarking the page for later :) )

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts