You should only do the Refresh once and it should be with
backgroundquery:=False

You can set this in the Add command and make it the default.

--
Regards,
Tom Ogilvy

"Louis LAI" wrote in message
...

Thanks Tom Ogilvy & Sharad Naik

Actually the DoEvent i did tested it before, but not working for me.

and the function ".Refresh BackGroundQuery:=False" which coming up with
error in every first time to hit, the message display as "The process
already running at the back end".




--
Louis LAI
------------------------------------------------------------------------
Louis LAI's Profile:
http://www.excelforum.com/member.php...o&userid=15629
View this thread: http://www.excelforum.com/showthread...hreadid=271745