List boxes - control source property - Word VBA 2003

[gslow]

I am attempting to use a range in an excel spreadsheet as a countrol source
property for a drop down list box in Word VBA 2003. The documentation
examples refer to putting a spreadsheet range as the control source, but the
examples show a reference to a range of cells, with no reference to the
spreadsheet in which they are contained. How is the excel spreadsheet itself
referenced? The documentation does not seem to address this issue.

 

[Jean-Guy Marcil]

gslow was telling us:
gslow nous racontait que :

I am attempting to use a range in an excel spreadsheet as a countrol
source property for a drop down list box in Word VBA 2003. The
documentation examples refer to putting a spreadsheet range as the
control source, but the examples show a reference to a range of
cells, with no reference to the spreadsheet in which they are
contained. How is the excel spreadsheet itself referenced? The
documentation does not seem to address this issue.

Normally, in Excel, you use something like:

"WorksheetName!A1:E5"

But I have not seen the code you are using.

Also, you may want to post this in an Excel group as this is really an Excel
question...


--
Salut!
_______________________________________
Jean-Guy Marcil - Word MVP
(e-mail address removed)
Word MVP site: http://www.word.mvps.org