Excel 2003. I am programmatically creating a single workbook from multiple
workbooks. I selectively do a worksheet.copy from the various source
workbooks into the single destination workbook. When the process is complete
I always get a prompt about "You workbook contains links to other data
sources . . . do you want to update the links?" The first question is why do
I have links when the source workbooks had no links and when I copies sheets
from the source workbooks to the destination workbook? The second question
is, if having these "links" is inevitable, then how do I stop the prompt from
coming up every time? I have already tried:

WbNew.UpdateLinks = xlUpdateLinksAlways

I check this in the destination workbook under Edit--Links and it sure
enough is set to always update links without prompt,. Nevertheless, I get
the prompt every time anyways. Thanks for the help.
--
Dr. Doug Pruiett
Good News Jail & Prison Ministry
www.goodnewsjail.org