View Single Post
  #2   Report Post  
Cindy M -WordMVP-
 
Posts: n/a
Default

Hi Alessio

But a new problem arised, affecting very few (yet annoying) documents:
sometimes Word displays a dialog box titled "Select Table", showing NO
tables (nor sheets, nor anything else: just an empty list is shown).

I take it your macro code is setting up the link to the data source file
(OpenDataSource method)?

This sounds like the macro code is set up for a DDE connection in Word
2000, or earlier, and is being run on Word 2002 or 2003. The default
connection method in Word 2002/2003 is OLE DB, and it uses practically
the same syntax as the DDE connection. (IOW, MS didn't pay the right
kind of attention to backwards compatbility for the OpenDataSource
method).

You probably need to edit your code and add the SubType argument to the
OpenDataSource method. Record a macro to create a DDE connection to this
type of file to get the value you need to pass to the argument.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question
or reply in the newsgroup and not by e-mail :-)