Change Connection using VBA

[tlindeman]

Is it possible to edit an existing connection (called Invoices) and change the command text to equal a paste special? I am recording a macro to connect to a SQL database and I need to be able to change the command text to a different date each time. I can set it up in excel, I just get stuck on how to change the comman text in VBA. If you need more information , let me know.

Thank You
Tony

 

[jthalliens]

Perfect thank you very much, I was on the right track, I just used dim MYVALUE as object and it failed. In any case I really appreciate your help.

Tony

Hola,

I´m doing something similar in regards a project I have with vba, but I would like to retrieve the result of .commandtext to a specifi Cell

something like Sheets("Sheet1").Range("G1").value= .Commandtext = "Select top 1 data From Orders"

Any help would be really appreciated.