Re: Problems merging an excel file due to code or file problems?

Discussion in 'Microsoft Excel Programming' started by Cindy M -WordMVP-, Sep 14, 2004.

  1. Hi =?Utf-8?B?SmFzb24gTA==?=,

    [Coming from the Word.mailmerge.fields group]

    Which version of Word/OFfice are we dealing with, here?

    What issue were you having with "text" fields, more exactly?

    Is the data range in the Excel table on the first sheet? Does it start in cell
    A1? Have you applied a range name to it? You probably should do the last, at
    the very least.

    > I posted an earlier question regarding formatting excel cells as text for
    > importing purposes. That seems to be working okay, but now I have another
    > problem. After this file has been saved, I need to merge it into a Word
    > source. When I do this, I step through the merge wizard, and after I choose
    > the Excel sheet and click OK, I get another strange window asking me to
    > select a table. Thing is, there is no table to select. I have to click
    > Cancel. If I try to click OK it say Word unable to open Merge Source. I
    > don't know what I did or what happened. I've tried this several times by
    > changing the cells formatted as text (errors were displayed cells because
    > they were formatted as text) to General. Still didn't work. I am posting
    > this on Word sites, because I don't receive this error until I try to merge
    > with Word. I don't think it has much to do with Word, though. Here is my
    > code. I am basically trying to figure out if there is something in my code
    > that could have screwed up this process. It was working fine before I
    > altered the code to format the first five cells as text.

    Cindy Meister
    INTER-Solutions, Switzerland (last update Jun 8 2004)

    This reply is posted in the Newsgroup; please post any follow question or reply
    in the newsgroup and not by e-mail :)
    Cindy M -WordMVP-, Sep 14, 2004
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Frank Jones
    Peter Huang
    Jun 15, 2004
  2. moonwalker

    Merging 2 excel file into single excel

    moonwalker, Feb 25, 2006, in forum: Microsoft Excel Programming
    Feb 26, 2006
  3. moonwalker

    Merging 2 excel file into single excel

    moonwalker, Feb 25, 2006, in forum: Microsoft Excel Programming
    Feb 25, 2006
  4. Haim
  5. Hemakumar

    due to failed Com Exception failed due to the following error: 800

    Hemakumar, Jun 10, 2009, in forum: Microsoft Excel Programming
    Patrick Molloy
    Jun 10, 2009