Dixie

That property in XL97 is Sql, as in

Sheet1.QueryTables(1).Sql = "SELECT ..."

--
Dick Kusleika
MVP - Excel
www.dicks-clicks.com
Post all replies to the newsgroup.

"Dixie" wrote in message
...
Does excel 97 have a property that is comparable to
CommandText in Excel 2000? I am writing a macro that
uses an input box to ask the user to select the data. The
input then uses an SQL statment with CommandText to
display the segment of data on the spreadsheet. The macro
is written in 2000 however I need the same functionality
for Excel 97.