Lazy aren't we?
As I said before, you can run your query or refresh from the macro and you
can even set up the macro to run automatically. Look in vba help index for
ONTIME

--
Don Guillett
SalesAid Software

"vigfus" wrote in message
...
It works! Thanks!

I changed copy to cut to make it more noticeable when the macro runs. Now
that i've gotten this far i have grander goals. ;)

I still don't know how to automate the macro. I still have to be there to
start the macro. It would be neat if the macro could start automaticly
when
some value appears in the raw data page (at the place i cut it from). Is
this
still possible?