Option 1 would be ideal.. but i have no access to change or fix the original
query... and the IT dept doesn't seem to know anything about it or have the
desire to help me with the situation.

Option 2 is what i'm trying to accomplish... and the problem i am having is that
i can tell it to close.. but as the spreadsheet has never been saved before i
get the save as dialog window.. and cant seem to figure out how to send
keys/control it .. that's my stumbling block... i haven't been able to get
control of the instance to use the saveas/ close vba that i'm used to using in
one instance of excel. any ideas on it?