haha, i was just about to ask how to delete temp files by macro (i m a newbie)

and it seems that the error is really related to temp files...just wrote a macro to do web query refresh and run into the same "run-time error 1004" problem, and the problem is gone once i delete the tem file.