Copy and paste in VBA
 

Look in the Data menu as the consolidation function.

--
Regards,
Tom Ogilvy

"James Weaver" wrote in message
...
Is there a way to copy and paste data from one file to
another WITHOUT opening the source data file?

In addition, is it possible to do this from multiple files.

I am trying to design a financial consolidation tool to
add up the same worksheet from multiple versions of the
same file.

Copy and paste in VBA
 

I have about 20 files with about 9 columns and 400 rows of
data - this function will take ages to set up...is there
any other way?

I was thinking of trying to write some code that will
paste - special - values the entire sheet from each
workbook (without opening it) into the Consolidation file
and then running a sum through each of the pasted
worksheets. Am just struggling with the code to get the
sheets into the Consolidation file...any ideas?

James

-----Original Message-----
Look in the Data menu as the consolidation function.

--
Regards,
Tom Ogilvy

"James Weaver" wrote in message
...
Is there a way to copy and paste data from one file to
another WITHOUT opening the source data file?

In addition, is it possible to do this from multiple
files.

I am trying to design a financial consolidation tool to
add up the same worksheet from multiple versions of the
same file.


.

Copy and paste in VBA
 

Try this James

It will open the files(you don't see that)
You find a link to a example on this page

http://www.rondebruin.nl/tips.htm

--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)
www.rondebruin.nl



"James Weaver" wrote in message ...
I have about 20 files with about 9 columns and 400 rows of
data - this function will take ages to set up...is there
any other way?

I was thinking of trying to write some code that will
paste - special - values the entire sheet from each
workbook (without opening it) into the Consolidation file
and then running a sum through each of the pasted
worksheets. Am just struggling with the code to get the
sheets into the Consolidation file...any ideas?

James

-----Original Message-----
Look in the Data menu as the consolidation function.

--
Regards,
Tom Ogilvy

"James Weaver" wrote in message
...
Is there a way to copy and paste data from one file to
another WITHOUT opening the source data file?

In addition, is it possible to do this from multiple
files.

I am trying to design a financial consolidation tool to
add up the same worksheet from multiple versions of the
same file.


.