CommandText Property

D

Dixie

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.
 
D

Dick Kusleika

Dixie

That property in XL97 is Sql, as in

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

Ask a Question

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

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need Help with Macro Security 1
Re-assigning CommandText to an existing PivotCache 2
Pivot tables not refreshing after data source update 1
Word macro that can call cells out of Excel for a find and replace 0
Setting CommandText property of PivotCache fails if cache has >1 PivotTable 1
a better way to query? 4
Variables in Query Strings 1
Can't change connection property on querytable 4

Top