I have two worksheets which exist in the same folder. I can succesfully
manually update one from the other but if I try to do it automatically I
either get an error which says can't find file (which it can manually) or it
sits there and does nothing. Oddly enough I am however able to open the
source file from the second worksheet.

The file I am uploading from has a single worksheet 20 columns by 1300 rows
and is about 270k. The file I'm trying to upload teh data to is approx 35
colums by 1300 rows and takes up about 2.5MB

Has anybody else experienced this and has a solution or have I missed a trick?

--
Thanks

Pete

Hi,

How does OLE play into this? And what do you mean can't do it automatically
but can do it manually, are you running VBA code and if so show us the code?

Cheers,
Shane Devenshire

"Pete Phillips" wrote:

I have two worksheets which exist in the same folder. I can succesfully
manually update one from the other but if I try to do it automatically I
either get an error which says can't find file (which it can manually) or it
sits there and does nothing. Oddly enough I am however able to open the
source file from the second worksheet.

The file I am uploading from has a single worksheet 20 columns by 1300 rows
and is about 270k. The file I'm trying to upload teh data to is approx 35
colums by 1300 rows and takes up about 2.5MB

Has anybody else experienced this and has a solution or have I missed a trick?

--
Thanks

Pete