Macro to Refresh Import Query

I set up an external data query using the import feature. I selected a .csv file. It worked. When I right click and hit refresh, it pops up a window and i click import and it refreshes. But when I record the refresh process and try to play it back it doesn't seem to update??? The code doesn't error out but no data updated. What's wrong??

Here is the code the recorder spit out minus the select commands.

Please Login or Register  to view this content.

Ok...when i put this in a standard module it seems to work great...I had it in a worksheet module to begin with.