activesheet.querytables(1).Delete

adjust to refer to the correct table.

--
Regards,
Tom Ogilvy




"Gary Keramidas" <GKeramidasATmsn.com wrote in message
...
after refreshing the external links to a text file, what's the best way to
remove the links and just save the values?

--


Gary