User Profile

Collapse

Profile Sidebar

Collapse
jfarley
jfarley
Last Activity: Apr 4 '07, 09:49 PM
Joined: Apr 2 '07
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • jfarley
    started a topic Open word merge without Select Table dialog?
    in Access

    Open word merge without Select Table dialog?

    I am trying to open a Word merge document from Access, pulling data from an excel spreadsheet. Got it working (thanks to help from this forum!) except for one thing. When the Word document opens, it asks me to select a table, even though I've specified a Connection string. I create this excel file new each time my process runs, so I don't believe I can specify a range. Is there anyway around user input on this? Here is some of my applicable...
    See more | Go to post
    Last edited by NeoPa; Apr 10 '07, 02:22 PM. Reason: Tags
    • jfarley
      replied to Dim objDoc As Word.Document isn't working!
      in Access
      Thanks for your fast help! That did it.
      See more | Go to post

        Leave a comment:

      • jfarley
        started a topic Dim objDoc As Word.Document isn't working!
        in Access

        Dim objDoc As Word.Document isn't working!

        I have been searching everywhere to try to figure out how to use Access to open an existing Word document that is merged to an Excel spreadsheet and merge the data when it opens. I'm working with two different version, Word 2000 and 2003. I got it to work perfect in 2000, but when I use it in 2003, the Word document opens and it is not linked to a data source.

        The closest thing I have found to help me out is a function written...
        See more | Go to post
        No activity results to display
        Show More
        Working...