paste special

[merf]

Hi,

I'am working with excel 2000 with an os win2000.
I use 2 different excel-files, one workfile where the data can be changed .
Al the formulas are in this first file and the second file I use only to
copy it to different persons. In this(second) file , there are only the
results(value), no formulas .

I want to paste the range(c3:k45) of a file1(sheet1) into another
excel2-file, wich is still closed, but only the values. Reason is that excel
will try to update the link to the first excel-file when the try to open
the second file and that's exactly want i doesn't want.

the range has to been pasted on the second file on worksheet1 also in the
cells c3:k45 .

I don't know how to fix it , I will be suitable if all the code is behind
one buttom on the first excelfile and the user never sees the second
excelfile. Maybe It can be opened and closed afterwards from the first
excelfile.

many thanx, Merf

PS my english written is probably very bad , sorry

 

[Don Guillett]

How about a workbook_open event in the destination file that updates itself
from the closed source file.
range("a1").value='[Test File 2003.xls]Budget 2003'!$A$1