Argument 'Prompt' cannot be converted to type 'String'

[Arturo]

Hi,

I'm writing an application to change the queries in some Excel pivot tables
(like 300). I exctract the query, modify it and then replace it in the pivot
table. When I do the replacement I've got the error:

Argument 'Prompt' cannot be converted to type 'String'

Here is the code I'm trying to run:

Try
objPivot.EnableRefresh = False
stQuery = objPivot.CommandText.ToString()
objPivot.CommandText = QueryReplacement(stQuery)
Catch er As System.Exception
MsgBox(er)
End Try

Any ideas?

Arturo