Thanks for the reply MSweetG222

We thought of doing that, but the only problem is that the "external
program" that I was refering too actually is a "plug-in" for excel...sorry
for the mis-communication...I guess i meant that it's a third-party
plug-in...(Actually, it's from Reuter's, I think it's called powerplus or
something like that)...Anyways, the problem with saving the workbook, and
then using the copy to read our values is that as soon as we open the
workbook, the Reuter's stuff will automatically update and we have the same
problem...



"MSweetG222" wrote:

Jason,
I don't know if your workbook is too big to save as a different workbook
name and use the "copy" workbook as your reference. That way the external
prg can update the original and you can work with the copy.

FileCopy "C:\MyOriginal.xls" "C:\MyCopy.xls"

You can kill the copy when you are done.

Kill "C:\MyCopy.xls"


--
Thx
MSweetG222