modifying database query with VBA

I have a worksheet that retrieves a months worth of valid data out of an oracle database. This works great but i would like to be able to modify what month and year the query requests in the background so the user does not have to go through all those button clicks in the wizard.

After looking through the help and searching here it seems like its possible, but i havent worked with excel's odbc before so i'm a bit new, i do know sql though.

i already have a button that activates a macro to do other things in this worksheet, so i can fire a seperate macro from that as well.

all i am interested in doing is modifying the sql and then refreshing the data with the new query.

thanks,

bsumner

anybody have a clue?

still need help.

still need help.

post your sql.

Prob best not to reply to your own posts as people will prob assume its been solved.

sql isnt the issue, i need to know the excel vba syntax to get the query, syntax to set the query (if it is different), and syntax to refresh the query.

just bumping my post as it goes a day without replies, which puts it way down on the 6 or 7th page.

thanks.